Row to Column Transformations

[wardoskibum]

Hey,

So, I am kind of new to Alteryx and been trying to figure out what tool/tools to best accomplish the following:

Input Data

ID	NAME	TITLE	ORG
1	Alvin	SrMgr	IT
1	Mike	Mgr	IT
1	Ryan	VP	ACC
1	Bill	Mgr	ACC
1	James	Mgr	ACC
2	Drew	VP	IT
2	Alvin	SrMgr	IT
2	Mike	Mgr	IT

Desired Output

ID	ORG	TITLE1	NAME1	TITLE2	NAME2	TITLE3	NAME3	PERSONNEL_CT
1	IT	SrMgr	Alvin	Mgr	Mike			2
1	ACC	VP	Ryan	Mgr	Bill	Mgr	James	3
2	IT	VP	Drew	SrMgr	Alvin	Mgr	Mike	3

Appreciate any thoughts or help on how best to go about this

[fmvizcaino · Accepted solution]

Hi @wardoskibum ,

Take a look at my example and let me know if that works for you.

I develop in this specific way to automatically order your columns the way you need it.

Best,

Fernando Vizcaino

[wardoskibum]

This is great, thanks!