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

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Watch MrExcel Video

Forum statistics

Threads
1,114,528
Messages
5,548,570
Members
410,851
Latest member
glowe2020
Top