I have Sheet A, were I have a column with Task Description that has parents. I created another column where I put the parents corresponding to the child.
Example:
Parent ID .........|........Task Description
[blankcell]........|........Parent 1
[Parent 1].........|............Task 1
[Parent 1].........|............Task 2
[blankcell]........|........Parent 2
[Parent 2].........|............Task 1
[Parent 2].........|............Task 2
On Sheet B I use =JOIN(DISTINCT({Parent ID}), ",") where I get all unique values from the Parent ID column on Sheet A as a string:
[Parent 1],[Parent 2]
What I want to do now is separate those parents into a list so that I can use the information for other metric related formulas. That is where I'm stuck, I don't know how to "unjoin" a string of text inside of a cell.
The goal is to get the names of parents (no duplicates) from Sheet A to Sheet B so that I can use them for formulas. This has to be automated, if there's manual work (adjusting ranges, fixing formulas every week, etc.) then this won't do.
Thanks for taking your time and hope you have a great day!