Thread: Pivot Table with lots of columns of source data
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Pivot Table with lots of columns of source data
At Step 1 of the PT Wizard, choose
Multiple Consolidation Ranges.
Make sure the column you want to use as ROW
is the first column.

Reply With QuoteReply With Quote