Pivot Table - Dates Running Horizontally

[SonicBoomGolf]

I am trying to create a Pivot Table, but am having some problems with dates that are running horizontal instead of vertical. Below is an extremely small sample of data for illustration purposes. In reality I have data from 1/2006 to 12/2008 in columns and thousands of rows of sold-to information.

My question is how can I make a Pivot Table when my dates run across the top of my data? Normally when I make a Pivot Table it is structured like the sample below with the dates running vertically.

Cust Year Month Amount
Depot 2006 Jan 10,000
Depot 2006 Feb 10,500
Depot 2006 Mar 11,000
Depot 2006 Apr 11,500
Depot 2006 May 12,000
Depot 2006 Jun 12,500

Here is a sample of how my data is currently structured with dates running along the top.

Calendar Year/Month
Sold-To 01/2006 02/2006 03/2006
6895 $ 3,603,029.59 $ 2,992,948.70 $ 9,050,020.61
6896 $ 1,971,855.51 $ 1,559,909.78 $ 1,892,599.17
6897 $ 520,054.91 $ 223,484.13 $ 696,829.34
6898 $ 374,646.28 $ 368,554.75 $ 254,575.42

Here is a sample of what I want the Pivot Table to look like. Am I just missing something simple here? I'm a bit rusty with Pivot Tables, but I just can't seem to get this figured out. Thanks in advance for all your help!

Book1.xls
	A	B	C	D	E	F
3	SumofInvoiceAmt		Month
4	Sold-To	Year	Jan	Feb	Mar	GrandTotal
5	6895	2006	3,603,030	2,992,949	9,050,021	15,645,999
6	6896	2006	1,971,856	1,559,910	1,892,599	5,424,364
7	6897	2006	520,055	223,484	696,829	1,440,368
8	6898	2006	374,646	368,555	254,575	997,776
9	TOTAL	2006	3,603,030	2,992,949	9,050,021	15,645,999
10	GrandTotal		10,072,616	8,137,846	20,944,045	39,154,507
Sheet4

 

[mrhartley]

Hello, Can you drag cell C3 (Month) to just between the Year and Jan column?

This I think, will put your months back to the pivot tables original format.

~Mark