Changing Data Layout - Flip / Transpose Horizontal to Vertical & Vertical to Horizontal

Question

Hello Designer Community

I am new to Alteryx and hoping to get your help on what might be a fairly simple problem. I'm building a workflow and have a problem where currently, the output to xlsx results in the following:

AAAABBBBCCCCDDDDAK0000AL0473770140870AR65728000AZ491046511700CA1473685920791365953201444

However, the desired output should be:

AKALARAZCAAAAA00657284910147368BBBB0473770465117592079CCCC0000136595DDDD0140870003201444

Thank you in advance for your time and any guidance.

Source Data.xlsx

AngelosPachis · Accepted Answer

Hi @scottstarewicz ,

Using a transpose and a cross tab tools to switch between columns and rows should do the job

Regards,

Angelos