Transpose Text data to one line

Cathy

Hi Expert

I would like to transpose some text data from 3 columns roll to one line and sample data like this:

May I have your advice, thank you.

Raw Data

Transaction Reference	Instrument Number	Payment Amount
Beneficiary Name	Delivery Method	Current Status
Issue Date	Payment Location	Beneficiary Charges
ABC-00001	123456	10.00
Simon Lam	MAIL	PAID
03/05/2021	HKG	13.00

Expected Result

Transaction Reference	Instrument Number	Payment Amount	Beneficiary Name	Delivery Method	Current Status	Issue Date	Payment Location	Beneficiary Charges
ABC-00001	123456	10.00	Simon Lam	MAIL	PAID	03/05/2021	HKG	13.00

Krzysiek

Hey

Here is one way how you may achieve that.


Please note that if you are using Input Data Tool instead of Text Input I used, select option "First Row Contains Data" like so:

New Workflow2.yxmd