Forum Discussion
Conditionally concatenate data
I am struggling with creating a concatenated field. I would like to gather all the people who have status "0" together in a new cell and separate them by commas and sort them alphabetically. The re...
Hi Jane_newbie
It's not possible to sort by surname unless you split the names into 2 separate columns
I'd be tempted to use a Pivot Table to reference the data and then filter just for the 0s, then apply a formula to join the resulting items.
Do you have the formula =TEXTJOIN available in your version of Excel?
Thanks ... of course I can't sort alphabetically by last name the way the table is. I wasn't thinking. Duh.
I'll look into your suggestions about a pivot table. I haven't used that so I have some reading to do. I think I can manage the formula to join the values if I can isolate them. I'll look into whether I have the TEXTJOIN option as well.
Thank you for your reply!