View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jimmy jimmy is offline
external usenet poster
 
Posts: 59
Default Pivot Table Column Issue

I have a spreadsheet that has a row of stores starting in column A and the
column headers are all expense accounts going across the spreadsheet. Is
there a way to create a pivot table so I can pick and choose which columns I
want to see? I can't seem to figure it out. I can't drop the expense
accounts in the column portion because no data will populate.