Hi,

I have a pivot table that consists of a store number and vendor name in
the row. The total dollar amount is in the data. There are are more
vendor names than store numbers. When I run the pivot it gives me the
store number once and the fills in all the vendor names with the dollar
amount. Example:


Store Vendor2 Amount
2 a 1
b
2
c
3
d
4



I would like the Store # to be repeated. Any ideas?

Thanks,

Eddie


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=491967