San Jose, CA
|reply to nickstoy |
Re: [Excel] Add all fields to pivot table (in Row Labels) (Excel
And (last question, I promise) what is the SQL (or whatever DB) query & first 10-20 rows of the result look like?
Basically, the "fields" you are showing above look more like values in a single column - no database in its right mind would have each of those as a field in a single record. So, I am wondering how the source data is organized.
My place : »www.schettino.us
| That's where it gets complicated. I get the data thru a vendor portal, which downloads to .txt. I then import it to Excel.|
Basically, I have two data tables. I don't know exactly how we call them, it's the type where you have populated fields in both axis, but data only where the two joins. I'm inculding a dummy screenshot just for the sake of understanding.
Both tables contain similar fields, and my goal is to end up with one table.
1st table contains a list of stores on the vertical axis, and different planogram names on the horizontal axis. Then there are "X"s to tell us which store has which planogram.
2nd table has Product names on the vertical axis, and planogram names on the horizontal axis. Then there are numbers to tell how many facings we should carry in that planogram, for that product.
Basically, what I need is one big table telling me which store carries what product, and how many facings.
Oh, and just to make this fun, there are over 1000 planograms, over 60,000 products, and 900 stores.