Dear all,

I'm having a problem with the shape of my data. It is formatted as follows:
YEAR id1 id2 id3
year1 0.05 - -
year2 0.04 - -
year3 0.06 - -
year1 - 0.01 -
year2 - 0.02 -
year3 - 0.01 -
year1 - - 0.10
year2 - - 0.09
year3 - - 0.11
what I need is:
YEAR id1 id2 id3
year1 0.05 0.01 0.10
year2 0.04 0.02 0.09
year3 0.06 0.01 0.11
I'm quite sure the solution is very simple but I can't figure it out.

I would appreciate your help.

Thank you very much!