How can I join non-consecutive parent and child rows into a single name.
I've searched the community and can't seem to come up with an adequate answer. I've made myself a helper column, and I'd like to join or concat the parent with each of the child rows, but I keep coming up unparseable. Here's what I'd like to do.
I'd like to have "Start-Task 1" show up next to Task 1, and "Start-Task 2" show up next to Task 2. I'm going in circles trying to figure out how to join the parent with Task 2 with a delimiter in between.