Hello,
I need help merging multiple rows together. I have data that's in the original data format and I need the end result format. I need to combine row 1&2, row 3&4 , row 5&6...etc. My data is never consistent and will always be differ. I also want the workflow to automatically combine the correct rows together no matter how many rows are there. There will always be an even amount of rows. Thanks.
Original data:
| Deposit 21,000 |
| Savings 0000000 23,000 45 Doe, John 21,000 02-10-2020 |
| Withdrawal 350 |
| Checking 1111111 12,362 45 Smith, Jane 350 02-10-2020 |
End result:
| Deposit 21000 Savings 0000000 23000 45 Doe John 21000 02-10-2020 |
| Withdrawal 350 Checking 1111111 12362 45 Smith Jane 350 02-10-2020 |
