Pivot Table with Multiple Row Fields

[Matt Cromer]

I know pivot tables are used to summarize information, but for my application
I need to fill in. e.g.
(Normal Pivot)
Item Desc Region Week 1 Week 2 Week 3
XXXX XXXX XXXX XX XX XX
XXXX XX XX XX
XXXX XX XX XX
XXXX XX XX XX

(Would Like)
Item Desc Region Week 1 Week 2 Week 3
XXXX XXXX XXXX XX XX XX
XXXX XXXX XXXX XX XX XX
XXXX XXXX XXXX XX XX XX
XXXX XXXX XXXX XX XX XX

Region is made up of many stores, so even though it has item and desc on
every line it is still rolled up from store to region level.

 

[Debra Dalgleish]

The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat.

To create the table with a heading on each row, you can copy the table,
paste it as values in another location, and fill the blanks:

http://www.contextures.com/xlDataEntry02.html

 

[Matt Cromer]

Debra -
Thank You. I used the macro and it worked perfectly. Good to know the GoTo
function as well.

Have a great day!

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that the macro helped.