guys
I am sorry if this has been asked before, but I will give it a try.
I have a table (tab delimited text file) that is formatted like this
Species1 Species2 Species3
Gene 1 Value Value Value
Gene 2 Value Value Value
Gene 3 Value Value Value
.
.
.
I need to change it to this format instead:
Gene 1 Species 1 Value
Gene 2 Species 1 Value
Gene 3 Species 1 Value
.
.
.
Gene 1 Species 2 Value
Gene 2 Species 2 Value
Gene 3 Species 2 Value
.
.
.
etc.
Is there a specific unix command to do this? Or may it be done directly in Excel or something? The table has almost 120 k data points, so I think doing this manually is out of the question.
As you can probably tell, I am not exactly an expert in these things.
Thanks in advance.
Asked by MartinOdegaard
(1 rep)
Nov 30, 2020, 03:48 PM
Last activity: Nov 30, 2020, 03:59 PM
Last activity: Nov 30, 2020, 03:59 PM