Move named data from rows to same named columns [Closed]

Report
Posts
1
Registration date
Thursday May 4, 2017
Status
Member
Last seen
May 4, 2017
-
I have a spreadsheet that has different test results for the same patient listed n multiple rows. I need to have all the results for the same patient on the same row with each unique test and its corresponding result presented in a different column. There would be a maximum of 30 possible tests/results per patient. For example,

From:

ID # Test Code Result
1 a neg
1 b pos
1 c neg
1 d pos
2 a neg
2 b pos
5 d neg
5 e pos
5 f neg
8 h pos

To:

Test Code
ID# a b c d e f g h
1 neg pos neg pos
2 neg pos
5 neg pos neg
8 pos

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!