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
It worked for the example I gave above but I just realized that this solution only works where there are 2 records, 4 rows. It doesn't work when there's only 2 rows or more than 4 rows.
