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:

[Cathy]

Transaction Reference	Instrument Number	Payment Amount
Beneficiary Name	Delivery Method	Current Status
Issue Date	Payment Location	Beneficiary Charges
1	2	3
4	5	6
7	8	9
1	2	3
4	5	6
7	8	9

Thanks for prompt reply, it's work.

May i know if have two or more groups of data (presented like items 1 to item 9, and next set of item#1 to 9), may i have your advice how to amend the "tile" settings, so that the workflow could be create two lines of data.

[flying008]

Hi, @Cathy 

FYI. (There is a half dynamic solution for you, don't need manual rename or order the field. )

[Krzysiek]

@Cathy

Attached modification of my previous workflow should be working no matter how many row of data you will import for your template.