How to split the values in a cell

Sshasnk

I have multiple values in a cell and the number of values in the cell will always be even and I have to slit in half but if value is present we have to leave it

Input:

amount	cash
123 456 254 145	145 784 159 354
457 456
784 564 145 456
457 145

Output:

amount	cash
123 456 254 145	145 784 159 354
457	456
784 564	145 456
457	145

echuong1

I'd start off by identifying each of the rows, so I can get a count of how many total record there are. I used a text to columns with a new line as the delimiter. I added a record ID so I'd know where these records originated from. I then used a summarize to get a count of the records, and a formula to divide by 2. I then separated out any of the rows associated with the bottom half using the count and a filter. I then used summarizations to concatenate the values back to one cell per group, and a join to assign the cash and amount values.

New Workflow2.yxzp