Pivot Table

S

Shaylee

I would like to know how to repeat the first of two field columns. I have a
table that has the first column as the customer and the second column as the
material and the data is the price. I want the customer to be on each line
with the individual material number instead of only the first one. How is
this possible?
 
D

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 in the blanks,
using the technique shown here:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Average Question 4
Pivot Tables- SQL Alias' & Field Lists 1
Showing data unigue to multiple columns in a pivot table 1
Table Data Missing 4
calculating differences in a pivot table 3
Selective extraction of data from a table 10
vlookup error 1
How do I create a drop down box within a drop down box? 1

Top