I have the need to combine different excel sheets of data into one single master file.
I have one master file with e-mail addresses and several excel-files from our CRM with data in different columns.
Is it possible to create some sort of pivot where I use emailadress as a key and just add the columns I want to combine? As an example
Row 1: email@example.com John
Row 2: firstname.lastname@example.org Doe
Need for result
Row: email@example.com John Doe
One of the files is the master. I only want to enrich the columns in that file, if the same email address is found in the other files and only for the columns I have created in the master file.
A little simplified as I have tens of thousands of rows.