View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bmac bmac is offline
external usenet poster
 
Posts: 30
Default Show all values in first column of Pivot Table

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