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 · Accepted solution]

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.

[Qiu · Accepted solution]

@Sshasnk 
Something like this?