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 publication they receive(IS, JH, NY, US ect.)
123 main gets a IS and JH so he shows up in row 1 for IS and again for row 2 JH. I want to simply have it show in row 1 with "IS - JH" in column B.
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!
