Combining two rows into one

[aminatag]

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

[binu_acs · Accepted solution]

@aminatag 

[aminatag]

Hi, thanks for the solution!

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. 

[binu_acs]

@aminatag updated the workflow for a dynamic solution