Unmerge cells, copy values and transpose multi rows

[Kevincoco]

Hi the Alteryx community,

I would need some help to figure out a workflow that transform the data that I have in tab "sheet 1" into format of the tab "sheet 2".

I already spent some time with transpose and multi rows formula without any success 😞

Any idea? I attach the excel file and screenshots of the tabs.

Thanks in advance 🙂

Kevin

sheet 1

sheet 2

[JulioMO]

Hi @Kevincoco 

I attach a workflow that does what you asked. 

Hope it helps!

Regards.

[Kevincoco]

Thanks JulioMO 🙂

Exactly what I wanted!

Now how would you (using the workflow) bring back the data to the old structure?

Background:

Here i want to update the product information in Alteryx and then bring back this info to the excel file

[JulioMO · Accepted solution]

Hi @Kevincoco 

Let me know if this workflow to bring back the info works for you.

Regards

[Kevincoco]

Thanks JulioMO 🙂