Pivot Talbe Help

[tmurcer]

I've got three columns.

A2:A7000 is customer number.
B2:B7000 is a circuit ID (unique telecom ID).
C2:C7000 is revenue

In Pivot Table:
Row Field = customer number
Row Field (to right of customer number) = circuit id
Data Item = Revenue

When the pivot is complete, the data looks like this:

Cust Number Circuit ID Revenue
123456 ABCDEF $10
FEDCBA $10
AABBCC $12

Each customer number has multiple Circuit IDs. Is there any way that
the Pivot Table can show the customer number with each unique circuit
id (3x in this case)? In my pivot table, the customer number appears
only once. I would like to be able to have the pivot return the
following, without having to manually manipulate the data.

Cust Number Circuit ID Revenue
123456 ABCDEF $10
123456 FEDCBA $10
123456 AABBCC $12

Thanks for any help.

Todd

 

[Debra Dalgleish]

The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat.

To create a table with a heading on each row, you could copy the pivot
table, paste it as values in another location, and fill the blanks,
using the technique shown here:

http://www.contextures.com/xlDataEntry02.html

 

[tmurcer]

Awesome Debra, exactly what I have been trying to do. thanks.

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that it helped.