Pivot Wizard transform Table to Matrix and rearrangement

Hi everybody,

I have a very bad source file which I need to aggregate. The point is that the source file is a Matrix, and I need a Table style. I used the Pivot Wizard to do so but now I have to re-arrange the output as per file attached.

The source file has 1 column with the SKU, and 80 columns with 4 KPIs repeating for 20 POS. THis means 81 columns. I did trasnform it to a table with tons of row but it's not over yet. I want to have in my final output only 1 column with the SKU, 1 column with the POS, and then 4 columns with the data for the KPIs. So a total of 6 columns and more or less 300 rows (that's the number of the sku).

I attached an example which is limited in number. Test.xlsx?

Anyone knows a fast way to do it without having to copy and paste stuff manually.

Thanks in advance. You'll save my life.

Regards,
Andra

Thanks a lot. That's indeed the output I wanted... but how did you manage to sort it that way? There is no formula behind. Hope it was not manual work.

Thanks
Andra

Thanks a lot. I received the folloqing error Compile error: Sub or Function not defined. Any ideas why that happened?

Thanks. I did copy that part in the macro, just underneath the one you posted above.

Now I get the message Compile error: ByRef argument type mismatch and this part of the macro is highlighted: Public Sub ClearFilter(sh As Worksheet, TableName As String)

Thanks.

Andra

Thanks a lot dflak, that worked brilliant! However, it is considering only the first 4 POS (times the 4 KPIs each, so it considers the first 16 columns)... How can I edit the macro in order to make it considering the whole amount of POS I have in my original file?

Thanks.
Andra

The OLD MKTG TS for Place D is not reflected in the Desired Output Table.