Probably a beginners question for most of you so apologies!
I have excel spreadsheet of 400+ mutations identified (each row is mutation identified hence multiple mutations in each patients sample)
I need to transpose the data so that each row is a unique patient and each column is a gene, however I then need multiple mutations in the one gene to be denominated
I then can add the clinical data
Any suggestions? Many thanks