Forum Discussion
Solved
Trying to consolidate a long list of notes
I have a list of nearly 41,000 individual notes. I have a column for notes and a column for contacts. Each contact may have multiple notes listed (from a single note up to dozens of notes). Simple a...
Let's say your list is in columns A and B.
Enter 'Contact' in D1 and 'Full Notes' in E1.
In D2, enter the formula =SORT(UNIQUE(B2:B11))
This will automatically spill to the cells below.
In E2, enter the formula =TEXTJOIN(" ",TRUE,IF($B$2:$B$11=D2,$A$2:$A$11,""))
Fill down from E2 by double-clicking the fill handle in the lower right corner of E2.
Maybe with Power Query as shown in the attached file.