Linking Excel tables with multiple similar fields

Question

Is there a way to link (or vlookup) two Excel data sheets having mutliple duplicate fields? For example, I want to join session and person data as described below (sample with dummy data):

Both sheets have thousands of rows.

The output should be somthing like that, e.g. for person 00001:

What output do you want? There are tools to do the join such as VBA SQL and powerquery and possibly range consolidation with pivottable wizard. But you do want a unique identifier and your Person ID at first glance seems a little confusing as has multiple tel numbers for 00001 and 2 of the Person IDs havbe multiple sessions so how you want the output to look is important. — QHarr
– QHarr, Commented Dec 13, 2017 at 20:18
@QHarr: edited my question, added a screen shot about the output. A user may have multiple phone numbers and can have multiple sessions. Any ideas on ho to re-arraneg the data are also welcome. — Peter_07
– Peter_07, Commented Dec 13, 2017 at 20:49

Peter_07 · Accepted Answer · 2017-12-18 09:50:52Z

0

Excel PowerQuery did the trick.

answered Dec 18, 2017 at 9:50

Peter_07

1173 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Linking Excel tables with multiple similar fields

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related