View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vbasean vbasean is offline
external usenet poster
 
Posts: 10
Default breaking apart columns in pivot table

I have a pivot that needs multiple columns instead of overlapping columns

here's an example

PivotField1
Item1, Item2, Item3

PivotField2
Item1, Item2, Item3

PivotField3...

when I place these columns along side each other this is what I get:
PivotField1, PivotField2, ...
Item1 Item2
Item1, Item, Item2 Item1, Item2, Item3

It keeps tiering off of each column and I don't want that.

I want Each column with it's own subcolumns SEPARATE.

Any suggestions?

Thanks