bmac,

You need to copy the pivot table and paste values somewhere else. Then
select that new table with the values, use Edit / Go To... Special Blanks,
then type =, press the up arrow key once, and press Ctrl-Enter. Then copy
the entire new table again, and paste special values.

HTH,
Bernie
MS Excel MVP


"bmac" wrote in message
...
Hello, I have a pivot table with columns A through M and rows 1 - 14,000
I have some duplicate values in coumn A. The values in columns B through M
are not unique within each column. Excel is grouping items B as shown
below.

A
B1
B2

And I want --
A B1
A B2

Any help appreciated,

Thanks