Breaking columns into a List on Excel.

How do I make a simpler list of a columnar report?

Example:
Take a table with column headings:
Date Cust Beer Chips Soda Cake
1/29 Jerry 6 1 2
1/30 Terry 3 4

And build a table with column headings:
Date Cust Product Qty
1/29 Jerry Beer 6
1/29 Jerry Chips 1
1/29 Jerry Cake 2
1/30 Terry Chips 3
1/30 Terry Soda 4

I am looking for a way to do this on a 700 row, by 30 column table. Accurately.
I can muscle it, Hav not found a way via pivot table