Forum Discussion
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 single spreadsheet.
2.) Merge multiple rows with varying column headers into a single row and have all the information merge into that single row.
Does anyone have a simplified means to do this without purchasing a separate software solution? If not, is there a software app out there that is relatively inexpensive?
I have attached an example of what I'm attempting to accomplish.
Thank you in advance for any assistance!
5 Replies
The combined use of FILTER and UNIQUE should work for you.
=FILTER(UNIQUE(A3:A6),UNIQUE(A3:A6)<>0)Demonstrated in the attached file, row 25.
Riny_van_EekelenWhere can I find a tutorial on how to do this on a large scale - 5000+ rows?
massieinc There is no tutorial. Just made it up based on the simplified example you gave. Looked att your larger file and notice that it contains a lot of blue shaded rows and red text, plus numerous hidden columns are hidden Some contacts seem to have only one row. Others have two, three or four (some including the blue rows and red texts). I haven't yet discovered a pattern in the data that could help automating the process. So if, you could clarify the meaning of the colors, hidden columns and how to identify the rows that need to merged together, that would be helpful.
Just one question remains. Is this a one-time process or will this have to be done on a regular basis?
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
ExcelExciting I'm using Excel 365. I don't believe the lists I'm working with have any unique identifiers. Larger example attached.
