Transposing dataset with multiple categories in rows

[wavincat]

Hello Everyone,

I have run into an issue with transforming input data, where I need to transform input data per the screenshot attached - essentially so that there is a separate row input for each customer for each month.

Main trouble is that Alteryx struggles to recognise the multi row categories and therefore transform it and so on.

CURRENT DATA FORMAT:
	2020	2020	2020	2020	2020	2020	2020	2020	2020	2020
	7	7	7	7	7	8	8	8	8	8
Category	Qty	Sales	COGS	Gross Profit	GP%	Qty	Sales	COGS	Gross Profit	GP%
Company A	1	2	3	4	5	6	7	8	9	10
Company B	11	12	13	14	15	16	17	18	19	20
DESIRED OUTPUT DATA FORMAT:
	Company	Qty	Sales	COGS	Gross Profit	GP%
2020-7	Company A	1	2	3	4	5
2020-7	Company B	11	12	13	14	15
2020-8	Company A	6	7	8	9	10
2020-8	Company B	16	17	18	19	20

Can somebody help with this ASAP? 

Thanks!!

[ArtApa · Accepted solution]

Hi @wavincat - Here is a possible solution for you:

[wavincat]

That's perfect. thank you for your help!!