Transpose like excel functionality

[Shank]

Hi All,

I need to transpose data similarly to excel can some one help on this.

Many thanks for your help

Input

Name	Year	Std	V1	V2
A	2018	NORM	Yes	Yes
B	2018	NORM	Yes	Yes
C	2018	NORM	Yes	Yes
D	2018	NORM	Yes	Yes
E	2018	NORM	Yes	Yes
F	2018	NORM	Yes	Yes

Desired Output

Name	A	B	C	D	E	F
Year	2018	2018	2018	2018	2018	2018
Std	NORM	NORM	NORM	NORM	NORM	NORM
V1	Yes	Yes	Yes	Yes	Yes	Yes
V2	Yes	Yes	Yes	Yes	Yes	Yes

[BenMoss · Accepted solution]

You can so this in two steps with Alteryx.

First transpose your data. Your name field will be your key field and everything else should act as a data field.

This will give you three fields. Name, Name2 and Value.

Next, use the cross tab tool.

Name2 will be your group by field, Name will be your headers field and Value will be your value field.

Give this a try and let us need further help or if it brings you to a solution.

Ben

[haroon_sa · Accepted solution]

Hey @Shank

Check out this solution. Hope it helps.

[Present_guy]

A development possibility...... add a single tool or parameter for "Excel transpose"? Students find it frustrating to have a transpose tool that is unlike their familiar transpose tool.  

[flying008]

Hi, @Present_guy 

Just like your need function in gallery.

[Present_guy]

Thanks - can you please provide a url? I searched for and couldn't find this. And interestingly, there are MANY posts about this issue in the discussions and several very helpful work--around solutions. 

[flying008]

Hi, @Present_guy 

here you are.

https://community.alteryx.com/t5/Public-Community-Gallery/Transpose-Excel-style/ta-p/904150