So, I have data that looks something like this, listing the placings in each competition :
(about 500 rows of it in total)
And I want to mangle it to look like this :
|1st Comp||2nd Comp|
And it should cope no matter how many competitions or different fencers are in the source list.
Or should I just stick to my awk script ?