Pivot Table Repeat Row Names

[largeselection]

Hi again,

I was wondering if there is any way to create a pivot table so that it repeats the row name rather than leaving blank space. As an example:
If I make a pivot table and A is divided in to 3 subsections, the pivot table looks like A in a box, with 1,2,3 next to that box, with A listed at the top. If I were to read it like a book it would read A1, (BLANK)2, (BLANK)3. It looks like the box A is a merged cell.

Is it possible to have A repeat for every row? So instead of having A in a box itself it would say A, A ,A for the three lines?
I would want the pivot table to read A1, A2, A3. Sorry if this is confusing. Any insight would be very helpful.thanks!

 

[c_m_s_jr]

It is not possible for a pivot table to return rows next to each value. What I have done is used formulas next to the pivot table to achieve the repeating row header.

So if your pivot table is from A2:J10 in K2 I would enter the formula:

=IF(A2="",K1,A2)

Copy and past down.

 

[joshtravis]

Perfect! I'm so happy I found this.