Transform sum table

Hi
What is the best way to do the following with VBA:
I have this table:

Please Login or Register  to view this content.

And I need to transform it to:

Please Login or Register  to view this content.

Note. I have a lot of companies, and this macro has to be run a log of times, so speed is an issue.

It can be done. Please attach a sample. Go to advance then attachment

Transform sum table.xlsx

I can only attach this file, since the original is confidential.

Originally Posted by AB33

Try attached

Wow!
This is awesome, and I can add companies and months !!

Thank you!

Martin,
You can add as much data input as you like, as long as the output remains on three columns. Beware also, I used a current region, so you should not have entire row or column blank in your raw data

Originally Posted by AB33

Martin,
You can add as much data input as you like, as long as the output remains on three columns. Beware also, I used a current region, so you should not have entire row or column blank in your raw data

Ok, cool

Martin,
Could you please now close (Mark) this thread as solved? Go in to the top right-hand side of this page, choose "Thread Tools" from the menu, then select "solved" from the drop down menu.