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

Report

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,

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

Move named data from rows to same named columns
A Macro to move data from rows to columns ✓ - Forum - Excel
VBA for deleting data in row but not formulas ✓ - Forum - Excel
How to move data in rows to columns ✓ - Forum - Excel
Moving data from rows into columns for every ✓ - Forum - Excel
Add data to row that already contains data ✓ - Forum - Excel

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

Your reply

Subscribe To Our Newsletter!