Move named data from rows to same named columns

kcliff Posts 1 Registration date Thursday May 4, 2017 Status Member Last seen May 4, 2017 - May 4, 2017 at 05:42 PM
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,


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


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