 JohnInSJPremium
join:2003-09-22
San Jose, CA
 ·PHONE POWER
 ·Comcast
| reply to nickstoy
Re: [Excel] Add all fields to pivot table (in Row Labels) (Excel Yep, sorry yesterday got away from me.
You have what we would call in the database world non-normalized data there
For a pivot table to work, your data should look like an relational database table: one row per record, where every row's columnar data is an instance of the same data.
So, for example, your data in relational form is
Product | Planogram
A | 4
B | 1
B | 1
C | 3
D | 2
D | 2
D | 2
D | 3
E | 1
E | 4
E | 4
E | 4
Store | Planogram
1 | 1
2 | 3
3 | 2
4 | 4
5 | 3
Is there any way to get the data in THAT format? I'll see if there's a way to decompose your source data into the proper form in excel.
--
My place : »www.schettino.us |
|
| 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  |
|
