|reply to JohnInSJ |
Re: [Excel] Add all fields to pivot table (in Row Labels) (Excel
yeah, you summarized very well my situation. The reason I posted in the first place is because I'm trying to get my data to be relational.
The thing is, the result would be more like this:
Product | Planogram 1 | Planogram 2 | Planogram...
A | 1 | 1 | 2
B | - | - | -
C | - | - | 2
Store# | Planogram
1 | 1-6-9-13-15-19...
2 | 2-12-13-16-19...
Ok, I've decided to give Access a try in order to blend those reports together.
Mods, you can lock this up.
Thanks to everyone who tried