对无标题的文本做行列转置

【问题】
I have a tab delimited file that looks as follows:

cat my file.txt

gives:

 1 299
 1 150
 1 50
 1 57
 2 -45
 2 62
 3 515
 3 215
 3 -315
 3 -35
 3 3
 3 6789
 3 34
 5 66
 5 1334
 5 123

I’d like to use Unix commands to get a tab-delimited file that based on values in column#1, each column of the output file will hold all relevant values of column#2 (I’m using here for the example the separator “|” instead of tab only to illustrate my desired output file):

299 | -45| 515| 66
150| 62| 215| 1334
50 | | -315 |
57 | | -35 |
| | 3 |

The corresponding Headers (1,2,3,5; based on column#1 values) could be a nice addition to the code (as shown below), but the main request is to split the information of the first file into separated columns. Thanks!

1| 2| 3| 5
299 | -45| 515| 66
150| 62| 215| 1334
50 | | -315 |
57 | | -35 |
| | 3 |

别人解答：