Dear All ,
I have a single file, which I need to rearange,
The file format is,
A1 ID* 3/2
A2 ID 3/3
A3 RM* 2/6
A1 RM 4/4
A2 D* 1/2
A5 D 5/3
A7 T 5/13
I need the output as this
ID ID* RM RM* D D* T T*
A1 3/3 3/2 ...
So on.. Its see where is the value in Column 1 belong to with respect to column2 and Need to print teh value from column3