View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default breaking apart columns in pivot table

When you drop your items, you can either drop them above or below. If I'm
reading right, you'd want to grap pivot field and drop, then drop the items
below the categories displayed.
Pivotfield1
list
drag and drop here

That what you were looking to do?

"vbasean" wrote:

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