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

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Watch MrExcel Video

Forum statistics

Threads
1,109,503
Messages
5,529,248
Members
409,857
Latest member
KailuaTown
Top