Data transformation - Data rows above headers into column

Question

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.

595595595587587587238238238238238238312312312Groupbrand_codenumSKUpricequantityStock_whCost pricequantityStock_whCost pricequantityStock_whCost priceSold qty StoreSold Value StoreCost of Sales StorequantityStock_whCost priceP01612P0201P020007101000000000000000P0315P0201P02005435135000000007.2632000007.2012P01912P0204P02008618420000000000000000P0802P0204P020169495390044.299620044.29874000000000P0802P0204P020169497750043.79502000000000000P0802P0204P0201695021000044.936910044.93691000000000P01912P0204P020385905000000000000000P0315P0201P02054613835000000006.37058000000

sample_data.xlsx

Aaron_Harter · Accepted Answer

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 Answer

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