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