How to move/match cell data to the corresponding column?

[JamiePitman]

Hello community,

I'm rather new to the Alteryx tool and I'm looking for some assistance if possible.

I have a table (example below), which contains a raft of repeating data fields, but with alternating responses.

Unique Reference	A
Name	A Person
DoB	01/01/1970
Unique Reference	B
Name	B Person
DoB	01/02/1980
Unique Reference	C
Name	C Person
DoB	01/03/1990

What I am aiming to achieve is to convert data like the above to a simple running data table like the below.

Unique Reference	Name	DoB
A	A Person	01/01/1970
B	B Person	01/02/1980
C	C Person	01/03/1990

Any assistance would be greatly appreciated and thank you in advance.

Kind regards,

Jamie

[griffinwelsh]

Here is a sample solution for you. There may be a more elegant way to do this, but this works.

[Bren_Spill2]

@JamiePitman - another option attached. Thanks

[JamiePitman]

Hello @griffinwelsh and @Bren_Spill, thank you both so much for your help!

Unfortunately I am unable to download files due system restrictions, as such, would you be able to provide me with screen grabs of the flows?

Thank you again and I am grateful for your support!

[Mathias_Nielsen]

Hi,

Here is my solution.

I reused some batching i had made for another workflow, this workflow batches by number. So in this case it will be by every 3 records. It works with the supplied sample data, but if you have more than 3 records you need to reconfigure the tools should be easy enough to spot where.

Here are the photos