Transform input data with multi row categories and dates

[IsabellaMortimore]

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.

Explained in example input and desired output file / screenshot

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

Attaching the sample file and screenshot of the sample file.

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?

Best,

[AndrewSu]

@IsabellaMortimore,  please see the attached workflow as an example of how you can accomplish the desired format.  

If this helps resolve your issue, please mark this reply as the solution so that others in the Community can benefit from our collaboration. 

Thanks!