Organize =Join(Collect formula Output

HelpMePlan

I have successfully pulled all of the Task IDs into one cell, but the information is not pleasing to look at. Is it possible to organize the output into separate cells?

Michelle Choate 2

Just an aside - it is best practice to name your ranges/references. So instead of "0017_Namibia Kunene - Project Plan Range 3" it would be something like "Kunene Project Plan Name" or "Kunene Project Plan Assessment".

You can separate things into separate cells. It just depends what you want where. You can use an INDEX/MATCH instead of a JOIN/COLLECT or an INDEX/COLLECT. The JOIN is what is bringing everything together in one cell.