Pivot from Many to Many

boehnc

Board Regular
Joined
Mar 26, 2002
Messages
58
Might be overthinking, but have two tables with the following columns below. I just need a pivot or table with the PatientA in the first table and each complication for PatientA in table 2...but it's a many to many. Thank you for any suggestion.

PatientA, DxCode1
PatientA, DxCode2
PatientA, DxCode3
PatientB, DxCode1
PatientB, DxCode2
PatientB, DxCode3


another table with related Students

PatientA, Complication1
PatientA, Complication2
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Watch MrExcel Video

Forum statistics

Threads
1,114,422
Messages
5,547,827
Members
410,813
Latest member
Vhinzvirgo
Top