Need to pivot my data from columns to rows
 

Hi,

I have columns that consist of CustomerName, Type, January, February, March
etc.
The rows have budgeted numbers for the year under each month for each
customer. I want to have my data so that it lists

Customer Type Month Amount
Joe Smith A Jan $400
Joe Smith A Feb $500
joe Smith A March $300


For each client. I tried doing a pivot table but am having trouble. I am
not trying to calculate anything just shift the data from columns to row.

Thanks,

Chuck

--
Chuck W

Need to pivot my data from columns to rows
 

I think you would have more success in using transpose - highlight the
data area plus headings and click <copy, then move the cursor off the
data area to where you want the first cell of the transposed table to
appear, then click on Edit | Paste Special | Transpose (check) | OK
then <Esc.

Your data should now have been transposed, and you can get rid of your
original data.

Hope this helps.

Pete

On Feb 8, 3:41*pm, ChuckW wrote:
Hi,

I have columns that consist of CustomerName, Type, January, February, March
etc.
The rows have budgeted numbers for the year under each month for each
customer. *I want to have my data so that it lists

Customer * Type * Month *Amount
Joe Smith * * A * * *Jan * * * *$400
Joe Smith * * A * * *Feb * * * *$500
joe Smith * * *A * * March * * $300

For each client. *I tried doing a pivot table but am having trouble. *I am
not trying to calculate anything just shift the data from columns to row.

Thanks,

Chuck

--
Chuck W