How-To fill down blank spaces in outlined table?

G

Guest

I'd like to convert an outlined pivot table into a flat table. I know that
once the table is copied onto a fresh spreadsheet (effectively removing the
active pivot) the blank cells can be filled down preserving the hierarchical
order. For example, let’s assume I have the following data:

Column A: (Area) EMEA
Column B: (Region) Western Europe, Central Europe, Eastern Europe
Column C: (Country) Denmark, Finland, Hungary, Greece

My table should list all Countries from column C; the corresponding Region
in column B; and the appropriate Area from column A.

I haven't used this routine in many years and I forgot how to do it. Any
ideas will be most appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to refresh drop-down list of pivot table 3
conditional formatting in pivot table 1
Need to determine where a change in table occurs 3
Excel 2002: How to sort row totals in Pivot Table ? 5
How to sort data in data area in a pivot table 2
What is the difference between a blank cell and a (blank) cell in Pivot Table ? 1
How to sort data in data area in a pivot table 1
How to include the Grand Total Column in a pivot table chart? 1

Top