View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DogEatDog World[_2_] DogEatDog World[_2_] is offline
external usenet poster
 
Posts: 6
Default Eliminating empty rows in Pivot table

Problem is that you can't simply filter out some data field because in some
row fields they have values and at some they don't. So what I essentialy need
is for those rows to exist when they contain data and to be erased when not
containing data.I hope that it+s possible in excel 2007