Combining rows of data that relate to one common item after parsing and unioning the data

[madslawton3]

Hello Community,

Please see the attached photo.

I have parsed some data separately from a string to get the output that I want; however, when i try to combine the two outputs, it comes up as the attached.

Basically, the data in row two for 'Credit/Debit' and 'currency' relates to the items in row 1 for 'date' and 'amount'. and same for the subsequent rows.

As such, I am looking for a way to combine rows 1 & 2, rows 3 & 4, rows 5 & 6 and so forth.

Is there a formula that would allow me to do this?

Thank you!

[bpatel · Accepted solution]

Hi @madslawton3 ,

you could use the multi-row formula tool. I mocked up a workflow from what your attached picture shows. I hope this helps.

[madslawton3]

Thank you so much!!!