My input data file looks something like this (only sample shown)

#id1
1 90
2 80
3 70

#id2
1 70
2 40
2 40
3 20
4 5

#id3
0 0
0 0
0 0
[download]

I am trying to output this input in the following format:

 id1 id2 id3
0         0
0         0
0         0
1 90 70
2 80 40
2    40
3 70 20
4    5
[download]

I tried using hashes, but didn't seem to work as the first column has duplicates. Any help how I can accomplish this. Thanks!