Forum Discussion
Combine multiple lead lists into one and merging varying information from duplicates.
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?
