dslreports logo
site
 
    All Forums Hot Topics Gallery
spc

spacer




how-to block ads


Search Topic:
uniqs
2
share rss forum feed


JohnInSJ
Premium
join:2003-09-22
Aptos, CA
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

nickstoy

join:2001-02-03
Saint-Lazare, QC
Reviews:
·TekSavvy Cable
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...

nickstoy

join:2001-02-03
Saint-Lazare, QC
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