Need to pivot my data from columns to rows

[ChuckW]

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

 

[Pete_UK]

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