Data Formating - Macro to copy header row and paste to multiple columns.

Hi Guys

I have a data table containing employees attendance records . There are basically two headers rows for each record
Looking for a VBA solution to copy the values from the Headers rows and transpose into new columns.
Attached is the Raw Data with desired output required.

Any help is much appreciated.

Thanks

Mysore