View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ChuckW ChuckW is offline
external usenet poster
 
Posts: 23
Default 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