Ungrouping the fields inside pivot table(Excel 2007)
 

Hi All,

I have a pivot table having 3 columns.

1:Date
2:Employee
3:Company

I am writing function, but problem is that it is grouping the fields like

3/1/2008 x company
y company
z company
4/1/2008 x company
y company


I want this type of structure not like privious one:

3/1/2008 x company
3/1/2008 y company
3/1/2008 z company
4/1/2008 x company
4/1/2008 y company

Ungrouping the fields inside pivot table(Excel 2007)
 

Pivottables won't let you do this.

You could copy the data and paste as values (a new location or over the
original???) and then use the techniques at Debra Dalgleish's site to fill those
empty cells with the value from above.

http://contextures.com/xlDataEntry02.html

arun wrote:

Hi All,

I have a pivot table having 3 columns.

1:Date
2:Employee
3:Company

I am writing function, but problem is that it is grouping the fields like

3/1/2008 x company
y company
z company
4/1/2008 x company
y company

I want this type of structure not like privious one:

3/1/2008 x company
3/1/2008 y company
3/1/2008 z company
4/1/2008 x company
4/1/2008 y company

--

Dave Peterson