I have a dataset as such:
Name: Jim Bean Vice: Dice ID: AFDSDFDSFDSFASFA LoginTime: 12343314 Name: Bob Dylon Vice: Trumpets ID: AFD232SFDSFASFA LoginTime: 12343314 Name: Mary Jane Vice: Gambling ID: EWDSFDSFASFA LoginTime: 12343314 .....
I need to arrange this into a columnar format. My first thought is to use
awk. But I'm a bit stuck.
The labels will always appear in the same order, also it will always show the same number of label/value pairs in each group (headers aren't important).
My question is: How would I do this?
I've seen hints that the command
rs may be able to do something like that, but its not standard on all systems.