Macro to change sheet - Horizontal (Time Allocation) to Veritical (Tablular) format?

[epalanis]

Hey Gurus, I am trying to reformat a sheet (Excel 2007) from Horizontal (Time allocation) format to Vertical (Tabular) format by using macros. Could you please help me out on this? The macro should be able to run on any number of rows and columns.

Sample Input Data

ITEM LOC 1/30/2011 2/6/2011 2/13/2011
1534 VLLF 5500 11000 5500
7945 VMED 100 5500 10
7529 VBOC 20 200 20
1674 VSAM 5376 0 0

Expected Output

ITEM LOC STARTDATE QTY
1534 VLLF 1/30/2011 5500
1534 VLLF 2/6/2011 11000
1534 VLLF 2/13/2011 5500
7945 VMED 1/30/2011 100
7945 VMED 2/6/2011 5500
7945 VMED 2/13/2011 10
7529 VBOC 1/30/2011 20
7529 VBOC 2/6/2011 200
7529 VBOC 2/13/2011 20
1674 VSAM 1/30/2011 5376
1674 VSAM 2/6/2011 0
1674 VSAM 2/13/2011 0

Please see attached spreadsheet (contain sample data) for both input and expected output.

Advance thanks all for your help.

EPalanis

[JBeaucaire]

Please Login or Register  to view this content.

The macro above is based on the ReOrganize macro published here:

Rows to Columns - Part 1a

[epalanis]

Thanks Jerry for your help. Much appreciated.