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

[scottstarewicz]

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:

	AAAA	BBBB	CCCC	DDDD
AK	0	0	0	0
AL	0	47377	0	140870
AR	65728	0	0	0
AZ	4910	465117	0	0
CA	147368	592079	136595	3201444

However, the desired output should be: 

	AK	AL	AR	AZ	CA
AAAA	0	0	65728	4910	147368
BBBB	0	47377	0	465117	592079
CCCC	0	0	0	0	136595
DDDD	0	140870	0	0	3201444

Thank you in advance for your time and any guidance.

[AngelosPachis · Accepted solution]

Hi @scottstarewicz ,

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

Regards,

Angelos

[scottstarewicz]

@AngelosPachis  Thank you!