Dear all,

I need a macro for converting a data given to me in columnwise excel data to a rowwise one.
let me clarify in another way.
lets take a sample data set
PersonelID 01/07/2012 02/07/2012 03/07/2012 ........
0001 A Class A Class B Class
0003 C Class B Class B Class
0004 C Class C Class A Class

I need this data in the following format
Personal ID Class Date
0001 A Class 01/07/2012
0001 A Class 02/07/2012
0001 B Class 03/07/2012
0003 C Class 01/07/2012
0003 B Class 02/07/2012
0003 B Class 03/07/2012
0004 C Class 01/07/2012
0004 C Class 02/07/2012
0004 A Class 03/07/2012

I would highly appreciate your help


Many thanks in advance...