Restructure Unstructured Excel Workbook

[Reghero]

Hello all!

I'm new to Alteryx and would appreciate any guidance. I have approximately 80 excel sheets (all in the same structure) and need to transform it to something simpler in order for the designers to visualize. I am able to do this in excel, but I would much rather let Alteryx do the heavy lifting and it makes future updates easier as well.

The request is straightforward, but I can't seem to figure it out.

[Qiu]

@Reghero 
The solution for this kind of unstructured data always inevitably becomes brutal force...😶

[Reghero]

Woah! Didn't expect that, but thanks for your help QIU.

The input dataset structure is not ideal . Unfortunately I'll have to attempt the brute force :(

My alternative is... Don't even want to think about it.😩