Forum Discussion
Troubles with textjoin formula
I need a formula that merges all my column A duplicates and combines the respective text in columns B (further explanation and example below) *A is addresses(123 main st) *B is the publicat...
In C2:
=TEXTJOIN(" - ", TRUE, FILTER($B$2:$B$1000, $A$2:$A$1000=$A2))
Adjust the ranges as needed.
Fill down.
Thank you so much for the prompt answer! I thought this would be harder to find so I had a couple posts up. Turns out there's multiple solutions!
The one you layed out worked, as well as
=TEXTJOIN(" - ",TRUE,IF(Table001__Page_1_21[ADDRESS]=E2,Table001__Page_1_21[pub],""))
This will shave around 15-30 minutes of "paperwork" before my route every night and so simple! Thanks again, have a great day!