P
punter
Hi,
I have a pivot table that consists of a store number and vendor name i
the row. The total dollar amount is in the data. There are are mor
vendor names than store numbers. When I run the pivot it gives me th
store number once and the fills in all the vendor names with the dolla
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,
Eddi
I have a pivot table that consists of a store number and vendor name i
the row. The total dollar amount is in the data. There are are mor
vendor names than store numbers. When I run the pivot it gives me th
store number once and the fills in all the vendor names with the dolla
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,
Eddi