Thread: How to ungroup fields in pivot table(excel 2007)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default How to ungroup fields in pivot table(excel 2007)
Check your other post.

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
Reply With QuoteReply With Quote