I have downloaded harmonised the TCGA-HNSC dataset and extracted it. It has 546 samples in total, so what I see in it are FPKM normalised values. The first column remains the same with 60000 rows and 2 columns that is first column ENSEMBL ID and second column FPKM value.
So now the issue is I want to join all the 546 txt file into one where the first column remains the same and rest 546 column would be joined. I'm using this command:
paste -d " " *txt > merged_file.txt
This is joining the all the data sets as ENSEMBL ID and FPKM value..
But I want 1st column as the ENSEMBLE ID and rest the sample FPKM any suggestion or help would be appreciated