Sort data from a JOIN(COLLECT( formula within a cell
I have a formula in one of my sheets that looks out across multiple columns and populates the cell with all values present in the columns for that row. I simplified the column names to make it easier to read, but here is the formula:
=JOIN(COLLECT([Data1@row:Data5@row, Data1@row:Data5@row, <> ""), ", ")
My question: Is there a way to have this data sort itself in ascending order when it appears in the cell?
I haven't been able to find a way to do this so far and would love input on what I can try to make this work.
Thanks so much!
Help Article Resources
Check out the Formula Handbook template!