SampleDataLabel.xls

What I am looking to accomplish.
"Fill the Empty Cells Left by Pivot Table Row Fields"
http://datapigtechnologies.com/blog/...le-row-fields/

Long story short, company I work for is using Excel 2007 and won't be switching over to Excel 2010. Curious if there is a macro that will accomplish the same thing "Repeat All Item Label" in Excel 2010.

Any suggestion is welcome! Thanks!