Transpose data

hzpetro

Hi

I ahve a data that consists 25 row. Column W i need to be the header and the qty should be follow. The rest of the data colum will be remain and the info will be required to be follow . The data as per attachment. I am quite new to alteryx and will need some guide

Book1_te.xlsx

davidskaife

Hi @hzpetro 

I think this will give you what you require.

First Transpose the data, where all columns are key, except for column AA as you want these to be vertical.

Then using a Cross Tab tool you convert W to headers, and Values column to the new columns. Note you have a duplicated year/quarter column in V, so I've omitted that. Cross Tab must have a method for aggregating which i've set to Sum, but as long as your group by is correct this shouldn't matter.

Finally i sort on column S to put it in the right order.

Hope this helps!

New Workflow1.yxmd