Semi-structured bloomberg ticker data to go into a clean 3 header table

Hi everyone, I'm halfway, or more like three quarters of the way to finishing this piece of code but I can't seem to figure out the last part.

I've got semi-structured data in Sheet1 that needs to go into a clean 3 header table in Sheet2. I've a hunch it requires just a few more lines of code but I can't put my finger on it. Any help is appreciated!

Is this the same request as the link one?

http://www.excelforum.com/excel-prog...ble-table.html

Nope. I learnt the code in the linked worksheet and applied it to another set of data, albeit within the same project. I did my 'homework'

But you have not commented on the thread, if my code works for you. The thread is still open.

So sorry! I've marked it as solved.

Thanks!
I have also got a solution for your latest post if you are not tired of arrays solutions.

Happy to hear your solution please

Okay! I have 2 codes
If sheet2 is your output sheet, the first code(Sub Doing_it_yourself1) and the output is in sheet4.
If your sheet2 is a sample output and the data go beyond the sample, Sub Doing_it_yourself2 is the code and the out put is in sheet3.