convert horizontal to vertical

I have a large spread sheet that is set up like below (example 1). I want to convert it to verticle (example 2). Example 2 will be in "pivot table friendly format" Is there an easy way to do that in one fell swoop? I am stumped on this one. Thank you.


EXAMPLE 1

DC Type Jan-08 8-Feb 8-Mar 8-Apr
68225 Gross Sales $450,781 $505,799 $525,418 $854,186
42244 Gross Sales $1,082,832 $2,045,248 $1,966,902 $1,479,986
45239 Gross Sales $973,195 $1,626,944 $1,210,509 $986,249
68225 Iincentives $ 575,963 $1,301,511 $1,473,719 $1,492,196
42244 Iincentives $1,001,224 $1,051,184 $1,247,438 $1,244,621
45239 Iincentives $844,135 $1,229,691 $1,038,124 $899,851


I need to convert to below

EXAMPLE 2

DC Type Date Amount
68225 Gross Sales 8-Jan $450,781
42244 Gross Sales 8-Jan $1,082,832
45239 Gross Sales 8-Jan $973,195
68225 Iincentives Jan-08 $575,963
42244 Iincentives Jan-08 $1,001,224
45239 Iincentives Jan-08 $844,135
68225 Gross Sales 8-Feb $505,799
42244 Gross Sales 8-Feb $2,045,248
45239 Gross Sales 8-Feb $1,626,944
68225 Iincentives Feb-08 $1,301,511
42244 Iincentives Feb-08 $1,051,184
45239 Iincentives Feb-08 $1,229,691
68225 Gross Sales 8-Mar $525,418
42244 Gross Sales 8-Mar $1,966,902
45239 Gross Sales 8-Mar $1,210,509
68225 Iincentives Mar-08 $1,473,719
42244 Iincentives Mar-08 $1,247,438
45239 Iincentives Mar-08 $1,038,124
68225 Gross Sales 8-Apr $854,186
42244 Gross Sales 8-Apr $1,479,986
45239 Gross Sales 8-Apr $986,249
68225 Iincentives Apr-08 $1,492,196
42244 Iincentives Apr-08 $1,244,621
45239 Iincentives Apr-08 $899,851

Okay, here's the way I learned to do it. This sounds complicated but once you've done it a few times, it's really quick!
First, you need to put the Pivot Table Wizard on your Quick Access Toolbar;
Go to Options>Customize>Commands not on Ribbon>Pivot Table & PivotChart Wizard> Add

Next: Insert a column Between Type and 1st date, label it DCType. Fill the column with
=A2&"$"&B2

Using the Pivot Table Wizard, create a pivottable from your new column to the right using "Multiple Consolidation Ranges", "I will create page fields", add your range, Finish
Part 2: Uncheck "Row" and "Column" leaving a very small pivot table (see example Sheet 4). Double click on the Value (i.e. 27107706) creating a normalized list (sheet5).

On this list, Insert a blank column before the date column. Use "Text to Column" to separate your DC$Type column delimiting with $. Relabel the columns DC, Type, Date, Amount.
Now you can make your pivot table. Any questions?

Edit: Added example file