I have a big data.txt file like this:
Code:
6712,04444
6712,02344
6712,02220
6712,02233
5322,00040
5322,02230
5322,42002
4444,03342
4444,03323
11,42023
11,00000
11,23443
11,23232
and then I want to make a data.txt like this from the original one:
Code:
col6712 col5322 col4444 col11
04444 00040 03342 42023
02344 02230 03323 00000
02220 42002 23443
02233 23232
In fact I want the first column of the original file be the column number and the inside of each row in original file be underneath of their related column. is there any command in Linux that I could reach my goal?