Need to reconstruct a data table

[BullCity]

I have a large table that I want to reconstruct. For simplicity sake, let's just says it's 3 rows (excluding headers) by 3 columns.

Item Description	1/1/2014	1/2/2014	1/3/2014
Cheese Burgers	2	3	4
Hot Dogs	5	12	6
Beverages	2	5	3

<tbody>
</tbody>

I want to reconstruct it so that the column headers become values in the table. The table headers are dates, in this case, if that gives clearer picture. So the new table would have 9 rows, (3 rows of data, excluding the header times four columns).

Item Description	Date	Quantity
Cheese Burgers	1/1/2014	2
Hot Dogs	1/1/2014	5
Beverages	1/1/2014	2
Cheese Burgers	1/2/2014	3
Hot Dogs	1/2/2014	12
Beverages	1/2/2014	5
Cheese Burgers	1/3/2014	4
Hot Dogs	1/3/2014	6
Beverages	1/3/2014	3

<tbody>
</tbody>

The above example is sorted by date but I would be indifferent if it's sorted by the Item Description.

Is there an easy way to do this? Pivot possibly? Again, my data table is large: 36 rows x 181 columns. Using the copy/paste/transpose feature is pretty impractical.

Thanks in advance!

 

[RonB1111]

This can be done by a Reverse Pivot Table. If your excel is version 2007 or greater, you bring up the old style Pivot Table Wizard by hitting the following 3 keys once each in this order: Alt D P (don't hold down the keys at the same time). Once the Wizard box pops up, this link explains the rest:
Spreadsheet Page Excel Tips: Creating A Database Table From A Summary Table

 

[BullCity]

Thank you Ron - very helpful.

 

[RonB1111]

You're welcome.