Sample Header Ad - 728x90

Transpose large table

0 votes
1 answer
167 views
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