PDA

View Full Version : Data Formating - Macro to copy header row and paste to multiple columns.



Mysore
12-31-2016, 08:06 PM
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
01-02-2017, 12:31 PM
Cross-posted:

http://www.excelforum.com/showthread.php?t=1168197&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.