Forum Discussion

Copper Contributor

Mar 10, 2020

Combine multiple lead lists into one and merging varying information from duplicates.

I am attempting to find a simplified workaround for an excel problem. I have multiple lead lists with different columns of information. What I'd like to do: 1.) Combine multiple lists into a singl...

Example of lists to combine and merge.xlsx11 KB

MVP

Mar 11, 2020

Hi massieinc

This could be possible to solve with the Power Query which in Excel, please add more sample data to your records as multiple combination will help to understand the pattern of data. Do you store any kind of unique ID for records in your data set. Unique ID will make the task very easy as your data-set might have multiple John Smith.

also please let us know your Excel version ?

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

massieinc

Copper Contributor

Mar 13, 2020

ExcelExciting I'm using Excel 365. I don't believe the lists I'm working with have any unique identifiers. Larger example attached.