Hello,
I have a large dataset with several columns with recurring identifiers in the first two columns. I'd like to move each recurring section into a new column.
For example:
Input file
1 ID-1 A
2 ID-1 B
3 ID-1 C
4 ID-1 D
5 ID-1 E
1 ID-2 F
2 ID-2 G
3 ID-2 H
4 ID-2 I
5 ID-2 J
Output file
1 ID-1 A ID-2 F
2 ID-1 B ID-2 G
3 ID-1 C ID-2 H
4 ID-1 D ID-2 I
5 ID-1 E ID-2 J
I can do this manually by using the filter tool to filter on column 2 (ID-1, ID-2) and then joining the resultant files, but this would be tedious, cumbersome, and altogether no fun since I would have to do this ~500 times.
Any ideas?
Thanks.
-Richard
are you open to creating or installing new tools? or using bash?
what type of solution are you looking for?
EDIT: I have a quick and dirty one-line bash solution. If your interested.