topic Re: Stuck on Cross tab / transpose in Alteryx Designer Desktop Discussions

Stuck on Cross tab / transpose

chickenlicken — Mon, 07 Jan 2019 16:41:54 GMT

Hey there,

I am stuck on what I feel is a simple problem but I cannot resolve! I have data structured as the first table below. I would like to transform it so that the Year becomes column header rather than row value - as per the second table below.

how do I do this?

		2016	2017
Tesco	Items Sold	45	30
Tesco	Items Bought	50	51
Sainsburys	Items Sold	32	34
Sainsburys	Items Bought	51	34
Asda	Items Sold	100	102
Asda	Items Bought	105	102

Re: Stuck on Cross tab / transpose

chickenlicken — Mon, 07 Jan 2019 17:04:33 GMT

I think I may have figured it out using this similar problem

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-transpose-table/td-p/21430

Re: Stuck on Cross tab / transpose

chickenlicken — Mon, 07 Jan 2019 17:06:39 GMT