Multiple Rows into Columns

Athilingam_S

Hi Experts

Please help me in Alteryx how can i insert respective rows details into columns ""Final Reports", "Reports" & "Recon""in the below scenario

Source

TXREFNO	Timings	Country
Details	Final reports
RCB2347026539	11/2/2001 11:10	US
CSK2180045069	12/3/2001 11:10	UK
MCBB128071969	1/3/2002 11:10	DE
Details	Reports
RCB2357026539	1/2/2002 11:10	US
CSK2190045069	2/2/2002 11:10	UK
MCBB118071969	3/5/2002 11:10	DE
RCB2347076539	4/5/2002 11:10	US
CSK2190645069	5/6/2002 11:10	UK
MCBB118071969	6/6/2002 11:10	DE
Details	Recon
CSK2180045069	7/2/2002 11:10	UK
MCBB118071969	7/18/2002 11:10	DE
MCBB118071969	8/3/2002 11:10	US
MCBB118071969	8/19/2002 11:10	DE
MCBB118071969	9/4/2002 11:10	DE

Expected Output

TXREFNO	Timings	Country	Details
RCB2347026539	11/2/2001 11:10	US	Final reports
CSK2180045069	12/3/2001 11:10	UK	Final reports
MCBB128071969	1/3/2002 11:10	DE	Final reports
RCB2357026539	1/2/2002 11:10	US	Reports
CSK2190045069	2/2/2002 11:10	UK	Reports
MCBB118071969	3/5/2002 11:10	DE	Reports
RCB2347076539	4/5/2002 11:10	US	Reports
CSK2190645069	5/6/2002 11:10	UK	Reports
MCBB118071969	6/6/2002 11:10	DE	Reports
CSK2180045069	7/2/2002 11:10	UK	Recon
MCBB118071969	7/18/2002 11:10	DE	Recon
MCBB118071969	8/3/2002 11:10	US	Recon
MCBB118071969	8/19/2002 11:10	DE	Recon
MCBB118071969	9/4/2002 11:10	DE	Recon

atcodedog05

Hi @Athilingam_S 

Here is how you can do it. If TxnRef is details then taking timing as details else take details from above details. This way you can fill the details and later filter out the txnref=details rows.

Workflow:

Hope this helps : )

details.yxmd