Transposing only part of row into column
I am trying to transpose the following row:
x1 x2 x3 x4
into
x1 X2
x3 x4
With tr ' ' '\n' < file I can select all columns to become separate rows, but as you see x3 and x4 have to be grouped when transposing....Or should I use awk for this one? Couldn't find solutions in the former transpose questions, so suggestions would be very welcome.
|