Merge / Combine Spreadsheets

Hello,

I have found a lot of information RE: merging and combining spreadsheets, but none addresses my needs specifically. I feel like this should be a simple process and I'm just missing something, so hopefully, someone here can point me in the right direction.

If I have two tables with DIFFERENT DATA, how do I combine them into one table with merged data, but only where email addresses match. See example below:

Table 1

NAME	EMAIL	VALUE 1	VALUE 2
James	james(at)anywhere.com	1	2
Sarah	sarah(at)nowhere.com	5	6
Joe	Joe(at)themiddle.com	12	13

Table 2

NAME	EMAIL	VALUE 3	VALUE 4
James	james(at)anywhere.com	3	4
Sarah	sarah(at)nowhere.com	7	8
John	john(at)southof.org	42	16

Merged Table

NAME	EMAIL	VALUE 1	VALUE 2	VALUE 3	VALUE 4
James	james(at)anywhere.com	1	2	3	4
Sarah	sarah(at)nowhere.com	5	6	7	8

I don't know how you did your merged table
but maybe this will be ok

NAME	EMAIL	VALUE 1	VALUE 2	VALUE 3	VALUE 4
James	james(at)anywhere.com	1	2	3	4
Joe	Joe(at)themiddle.com	12	13
John	john(at)southof.org			42	16
Sarah	sarah(at)nowhere.com	5	6	7	8

Hello,

Thank you for your responses, but I cannot tell from the attached spreadsheet how you completed the merge. The results table appears to have directly entered data, there is no formula that I can see.

I'm sure I'm missing something, so please excuse my ignorance. How did you accomplish this?

Thanks,

Rhys

this is Power Query and here is the M for that:

Please Login or Register  to view this content.

to see more try Alt PU E and then Alt H Q