Hi all friends,
I have a large excel sheet (2010) with two columns and thousands of rows for 3 samples. Please take a look at the attached file, which is the short example of my dataset (Original dataset, left side of file). However, I would like to have a dataset like what I showed in the right side of the attached file (Desired dataset). Actually, all IDs should be located in one column and their corresponding values from various samples have to be put in other columns and if a ID has not any value in the sample, it should be shown with 0. Also, some of original IDs, like AT5G01600.1, in the sample 2 are duplicated or even triplicated with different values. In this case, the mean value must be put for the corresponding ID, for example, 4.76 for sample 2, in the right side of file. I need an easy way to do this task for my large original dataset. Could you please help me out in this regard?
Thank you in advance
Bookmarks