Forum Discussion

ComputerHabit's avatar
ComputerHabit
Icon for Helper II rankHelper II
1 year ago

How do I merge a split row back into it's original form?

I am trying to split a column into rows, do a join to another column for lookups and then put everything back. Copilot gave me: I've gotten to step 4 but I don't understand what is happen...
Need Help
ComputerHabit's avatar
ComputerHabit
Icon for Helper II rankHelper II
1 year ago

I have a column with list values.


I've expanded the column to show delimited values.



I split by row



Now I'm supposed to group.  But the button for Group just does SUMs and Counts which isn't what the instruction shows.  I'm trying to piece it together. 

I'm not used to the interface and what to do.