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

Question

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 ReferenceANameA PersonDoB01/01/1970Unique ReferenceBNameB PersonDoB01/02/1980Unique ReferenceCNameC PersonDoB01/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 ReferenceNameDoBAA Person01/01/1970BB Person01/02/1980CC Person01/03/1990

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

Kind regards,

Jamie

Mathias_Nielsen · Answer

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

2024-07-19_14-23-08.png

2024-07-19_14-22-49.png

2024-07-19_14-23-27.png

2024-07-19_14-24-06.png

2024-07-19_14-23-44.png

JamiePitman · Answer

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!

Bren_Spill2 · Answer

@JamiePitman - another option attached. Thanks

Cross Tab Macro.yxzp