I know this has been asked before but I am still struggling. I have a set of data in which I want to transpose rows and columns for the report. It is of this format in the table, and in the report I would like the columns to be patient ID's and the rows to be BRCA1, BRCA2, PALB2, RAD52, PARP1, PARP2.
Patient ID BRCA1 BRCA2 PALB2 RAD52 PARP1 PARP2 SJTALL001.ETP -8.89873 -6.595905 -3.890829 5.4208493 -6.295533 -9.2605734 SJTALL002.ETP -1.9037342 -2.0763407 -6.8788815 -4.410863 11.15449 1.2569857 SJTALL005.ETP -2.9297638 -7.7500105 -1.8912506 -1.75654745 0.36532402 6.326957 SJTALL009.ETP -10.860171 -3.063228 8.4301805 2.42634487 7.227287 2.8921556 SJTALL010.ETP -2.9476643 0.11965513 -1.014266 2.3000331 3.7024355 2.511487 SJTALL011.ETP 11.24115 2.5265455 6.1173105 3.3252358 0.0630817 2.1886587