Repeat Item Labels for Excel 2007?

[Karthik-Excelsior]

Hey guys,

I use Excel 2010, wherein the pivot table 'Field settings' dialog box gives me the option of repeating the item labels.

However, I wanted to know if there is a workaround to Excel 2007 users? I don't see this option unfortunately. If it is indeed not available in Excel 07, can you suggest a workaround to it? Thanks!

 

[Andrew Poulsom]

You can't do it within the pivot table. You can do it on a range that is created by Copy/Paste Special Values:

Fill Blank Cells in Excel Column

 

[Firefly2012]

This is a workaround formula I typically use in Excel 2007:

Excel 2010
	A	B	C	D
3	Quarter	Company	Sum of Value	Quarter
4	Q1	Company A	-282	Q1
5		Company B	-766	Q1
6		Company C	-1803	Q1
7	Q2	Company A	-3072	Q2
8		Company C	-860	Q2
9	Q3	Company A	-444	Q3
10		Company B	-561	Q3
11		Company C	-297	Q3
12	Q4	Company A	1664	Q4
13		Company B	613	Q4
14		Company C	-354	Q4
15	Grand Total		-6162
Sheet4

Cell Formulas
Range	Formula
D4	=IF(A4="",D3,A4)