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 |
Solved! Go to 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.
@Sshasnk
Something like this?