Transpose stacked cell values into separate columns
Is there a way to split a stacked cell values into multiple columns with formulas?
So Col6 is the starting data that is dynamic, so it will change as forms are submitted so sometimes the cells have one name, sometimes they have 5.
I'm hoping the output would look like the below
Thanks for any help with this
Help Article Resources
Check out the Formula Handbook template!