• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Is there an easy way to fill the empty cells left by row fields?

Is there an easy way to fill the empty cells left by row fields?

Problem

When you turn a pivot table into hard data, you are not only left with the values created by the pivot table, but you are also left with the pivot table's data structure. For example, the data shown in Figure A.9 came from a pivot table.

Figure A.9. Notice that the Market field keeps the same row field structure it had when this data was in a pivot table. It would be impractical to use this data anywhere else without filling in the empty cells left by the row field.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint