hello, i need serious helo with this project i am having
i have data that i need to organize
ID test result
22 HB 12
22 WBC 25
22 PLT 300
25 HB 23
25 WBC 44
25 PLT 400
I want to organize it like this.
ID HB WBC PLT
22 12 25 300
25 23 44 400
hello, i need serious helo with this project i am having
i have data that i need to organize
ID test result
22 HB 12
22 WBC 25
22 PLT 300
25 HB 23
25 WBC 44
25 PLT 400
I want to organize it like this.
ID HB WBC PLT
22 12 25 300
25 23 44 400
Hi,
Select the data, copy it and then go to paste special and select the Transpose tick box.
Regards,
Stephen
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks