A Table into a Flat Table

[DaRook1e]

Hi there,

I have been scratching my head how to transform a table with two headers into a flat table in excel. Below is an image of what I am trying to reproduce using VBA. I am actually a complete noob in terms of VBA and am trying to basically understand ready coades and adapt them to my needs as much as I can since I am unable to rite my on codes... not yet at least. Would be grateful if someone has done a similar task before and can help me out.

Thanks
DaRook1e

 

[arunsjain]

Hi,

You can use power query for this type of transformation. Refer to link below

I hope it will help.

Cheers!!!

 

[DaRook1e]

Hi, I knew I could solve it with Power Query but I was wondering if VBA is not a better option. However, after watching the referenced video I am convinced that Power Query is the ultimate tool for this kind of data transformation. Moreover, after exploring the website and the offers I seriously consider to enroll any of the courses of the referenced instructor.

Thank you very much!