Repeat Row name in Pivot Table

[arnorian]

Hi

I have a Pivot table with two row variable; SKU (priamry) and Customer Name (secondary). What I need is for the SKU name to appear for every customer (I have some other formulas that are drawing from SKU name). I hope this makes sense. I have tried to add it into columns but names dont appear since Pivot thinks its value and just gives me a 'count' of my customers.

Currently:
COLUMN 1

SKU 123

Customer 1 Customer 2 Customer 3 SKU 234 Customer 1 Customer 5 Customer 7

<colgroup><col></colgroup><tbody>
</tbody>

How I need it to look
COLUMN 1 Column 2
SKU123 Customer 1
SKU123 Customer 2
SKU123 Customer 3

SKU234 Customer 1
SKU234 Customer 5
SKU234 Customer 7

 

[sheetspread]

Design--Report Layout--Repeat All Item Labels (and switch out of compact form)

 

[arnorian]

Perfect. Worked like a charm. Thank you