Show all values in first column of Pivot Table

  • Thread starter Thread starter bmac
  • Start date Start date
B

bmac

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
 
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
 
Back
Top