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.