Adjust a table - Swap some columns for rows

[FabioP]

Hello everyone!

Could you guys help me with the situation bellow?

I have a table like this:

I'm having trouble turning it into this:

I can't find a simple way to do that...

Follow the excel file with data.

Thanks!!

[BrandonB · Accepted solution]

I used a multi row to fill down the store, then a filter, and finally a couple of data transformation tools. Screenshot is below and workflow is attached!