I have a file that I need to reformat so that every time I match a certain string in the first column it prints to the string as the heading and under the sting it prints the remaining entries on the line that matched the string.

For example, I need to reformat this

Code:

xxx : yyy zzz
11 : 111 222 xxx
xyz : abc def
xxx : aaa bbb
11 : 555 333 yy
xyz : abc xyz

To look like this with xxx, 11 and xyz as the headers/titles for each column.

Code:

xxx              11                   xyz
yyy zzz        111 222 xxx      abc def
aaa bbb        555 333 yy      abc xyz