I'm getting it the way you're looking for it on my pivot.

I have a table of:

State Fruit
Washington Apples
Washington Oranges
Washington Grapes
Michigan Apples
Michigan Oranges
Michigan Grapes

and I get

Michigan Washington
Apples Grapes Oranges Apples Grapes Oranges

Maybe there's something more complex in the actual table that I'm not aware
of?

"vbasean" wrote:

no, when I place columns beside each other they overlap their sub columns.

take this for example

say I have States that send me fruit
Washington
Apples, Oranges, Grapes

Michigan
Apples, Oranges, Grapes

When I place these columns along side each other I get this tiered mess
Washington Michigan
Apples Apples
Apples, Oranges, Grapes Apples, Oranges, Grapes

and more convoluted


What I want is basic.

Washington Michigan
Apples, Oranges, Grapes Apples, Oranges, Grapes


"Sean Timmons" wrote:

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