Forum Discussion
Trying to consolidate a long list of notes
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.
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.
- Thanks, it helped with sorting about 50% of them, but I received #VALUE! errors for the other half. This does not seem to denote there are too many characters in the cell, as I combined several Contacts with the CONCATENATE function.
Could you attach a small sample workbook that demonstrates the error?
HansVogelaar Here is a sample of what I get back.
https://etteropscom-my.sharepoint.com/:x:/g/personal/todd_etter_etterops_com/EbJoxKcK9fhPtp6dwTIYB2ABO3a_Bqzc3eDDmcYqpmQTsA?e=j5IHP6
