How to transpose data using terminal?

Question

[Genosa]

Hi, sorry if this is a rather basic terminal question. I have a set of RNAseq output file which is in the current format:

gene    condition    replicate    fpkm 
B2M     untreated    0              800
B2M     Untreated   1               900
B2M     untreated    2              850
B2M     treated        0              909
B2M     treated        1              980
B2M     treated        2              809

And I wish to change the data to the format:

Gene  untreated  untreated  untreated  treated  treated  treated
B2M   800           900            850           909       980       809

What kind of command should I use please? Thank you!

[Pierre Lindenbaum]

it sounds like a XY problem . Why do you need to transpose this ?

[Genosa]

I am trying to make the data fit the GSEA format

[Pierre Lindenbaum]

please validate or comment your previous questions: How to merge column text files using terminal command? ; Terminal command for extracting & filter row data from large RNAseq TXT files ; GSEA blue and pink o'gram - how are they plotted? ; Calculating number of reads for paired end reads? ; ...