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.