• 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 in multiple ...

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

Problem

When you turn a pivot table into hard data, you are left with several blank columns. The previous method works fine for one column, but it could get tedious if you have to fill in several columns, such as with the pivot table shown in Figure A.14.

Figure A.14. You will want to fill in all blanks in columns A through C.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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