I have data I need to analyze with a Pivot Table, but I can't because there
are multiple columns. I have time series data, where the first column has the
item name, and the rest of the columns have weekly sales, one column per
week. However, I can't analyze it because I need the weekly data to be in a
single column (this is the only way I know how to analyze it and graph it).

Does anybody know if there is an easy way to stack this weekly information
into a single column, where the first column has the item name, second column
the date, and the third column the sales data? This will really help. Right
now it takes me 3 hours to re-arrange the data manually because there are
like 200 columns, each with 150 rows!

Thanks in advance.