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

[Mysore]

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

[Zack Barresse]

Cross-posted:

http://www.excelforum.com/showthread...8197&highlight

@Mysore: please read this post: http://www.excelguru.ca/content.php?184. Please make sure and read the "How to Post and When to Cross-Post" section.