Data transformation - Data rows above headers into column

[abdoul]

Hi community,

Actually i am facing a data transformation issue with Alteryx. 

I have a dataset with a row data that is above the header rows. 

My purpose is to transform the first rows the header which should be in a column name STORE_CODE.

I tried some solutions like transposing those columns with extra rows but never find a proper solution.

Can you please help, i will attach a sample of data?Thank you. 

					595	595	595	587	587	587	238	238	238	238	238	238	312	312	312
Group	brand_code	num	SKU	price	quantity	Stock_wh	Cost price	quantity	Stock_wh	Cost price	quantity	Stock_wh	Cost price	Sold qty Store	Sold Value Store	Cost of Sales Store	quantity	Stock_wh	Cost price
P01612	P0	201	P020007101	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
P0315	P0	201	P020054351	35	0	0	0	0	0	0	0	0	7.2632	0	0	0	0	0	7.2012
P01912	P0	204	P020086184	20	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
P0802	P0	204	P020169495	39	0	0	44.29962	0	0	44.29874	0	0	0	0	0	0	0	0	0
P0802	P0	204	P020169497	75	0	0	43.79502	0	0	0	0	0	0	0	0	0	0	0	0
P0802	P0	204	P020169502	100	0	0	44.93691	0	0	44.93691	0	0	0	0	0	0	0	0	0
P01912	P0	204	P020385905	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
P0315	P0	201	P020546138	35	0	0	0	0	0	0	0	0	6.37058	0	0	0	0	0	0

[DQAUDIT]

Hi @abdoul ,

Can you provide a sample of the desired output?  I'm not sure if that was in your attached Excel file, but I was unable to open (likely due to firewall on my side).

Thank you.

[Aaron_Harter · Accepted solution]

Hi @abdoul, 

I would recommend reading in your Excel sheet as raw data:

Then use the Transform & Join tools to break it apart and put it back together in your desired format:

 

[NicholasM · Accepted solution]

Hey @abdoul , 

This is for sure an interesting transformation example. I have given it a shot, please see the attached workflow and let me know if it gets you your desired output. 

Best, 

Nick Michels

[abdoul]

Thanks for your quick reply, @Aaron_Harter  and @NicholasM  lead pretty much to the same result which which solve a big part of my problem. 

But now is there a way to go a little bit further and have the result in SKU level the dataset is way larger than the sample that I shared so more than 100 STORECODES ?? I mean by that having only STORECODE for only the existing SKU and avoid the NULL value in the bottom of the result (please see attached image for what i am referring). Let me know if you have an idea.

@DQAUDIT  I hope that reply to your question about the result that i am looking for. I will attach as well again the sample for you. 

thank you.