Create an Summary List from a data set

I have the following Excel file (made up numbers):

Please Login or Register  to view this content.

and I'm trying to find a way how to code it so in a new file, I get the following: (I've already created the new workbook with the column names)

Please Login or Register  to view this content.

So basically, however many columns I have (GLR, CLR....in actuality I have 12 columns), that's how many times each RptLOB should be mentioned in my new file (the GLR, CLR values when the RptLOB is Disability and MSL, and so on - I have 46 different LOBs but this may change so I don't want to fix the amount)

What is the best way to approach this?

Any help will be appreciated!

rylo, exactly what is this code doing? (I'm a little new to VBA :/)

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

thanks!

Never mind! Got the RptLOB and ECMAccounts working.