Repeat Item Labels in Pivot Tables Excel 2007

Due to EXCEL 2007 lack the feature of repeat item label in pivot table, I found below creative ideas. tks for google and idea provider. 

​

1) Create a new column to the left of the one you want to fill in - let's call this column A, and the original one B
2) Copy B1 into A1
3) A2 = if(B2="",A1,B2)
4) Fill Down

So, if column B has a value, it copies it into A, else it copies the entry above the current cell in A - that's why we primed it with step 2.

​

​You can also:

-Select the row fields

-Press f5

-Choose Special... then blanks

-type = then press the up arrow then press Ctrl+Enter.

-Finally copy and paste special - values if required.