Advanced transpose macro (VBA help)

Hello smart people!

I am desperately seeking a better way of transposing a large amount of data in a non-standardized way... I have tried for 6 hours now with formulas and copy-pasting but it is extremely time-consuming and also not working that good. By the looks of other posts, my objective is possible with a bit of VBA. Sadly, I am almost 100% VBA illiterate, and therefore, I was hoping that a kind soul in this forum could help me I sincerely appreciate your help!!!

The data I have currently looks somewhat like this (see attached file) ("|" indicates new column.)

Code | Description | Remark | Intro date | Disco date | 2011_C05 | 2011_C06 | 2011_C07 | 2011_C08 | 2011_C09 | 2011_C10 | 2011_C11

There are eleven different "remarks" per product code, and 1107 product codes, meaning that there in total are 12199 +1 rows.

What I want is for it to look like this instead:

Date | Code | Description | Intro date | Disco date | (Remark 1) | (Remark 2) | ... | (Remark 11)|
2011_C05
2011_C06
2011_C07
2011_C08
2011_C09
2011_C10
2011_C11

and then when all data is inserted for the first product code to simply inserting the next product after that in a new row...

It will be easier to understand when checking the excel file.

Maybe I was wrong when I said that this is possible to make with a rather simple VBA, but if I wasn't then can someone please help me? I will be forever grateful!

Kind regards

Nils

Please Login or Register  to view this content.

Thanks a million!!! Worked 100%