+ Reply to Thread
Results 1 to 4 of 4

Making two crosstabs tables in one relational table.

  1. #1
    Registered User
    Join Date
    06-20-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    7

    Making two crosstabs tables in one relational table.

    I have two huge crosstab tables that I need to extract data from.

    First crosstab has a list of planogram names as horizontal axis, and store # as vertical axis. Data is merely "X" values, to indicate which store uses which planogram.

    Second crosstab has the same list of planograms as horizontal axis, but SKU numbers in the vertical axis. Data indicates the amount of facings each product has in the planograms.


    What I need as an end result is a relational database where I can know: what store carries what SKU, and how many facings.

    One thing making this a huge headache is the size of these tables: I have 1279 planograms, 924 stores, 872 skus.
    The other thing is one store carries about 40 planograms. But 1 sku will only be present in one planogram in that store.

    Hope this is clear enough.

    Including screenshots to make this clearer. (Dummy Data)

    end-result.png
    Please Advise??

    Thanks

  2. #2
    Registered User
    Join Date
    08-28-2012
    Location
    Indiana
    MS-Off Ver
    It changes depending on the job.
    Posts
    36

    Re: Making two crosstabs tables in one relational table.

    I'm not sure if this will help but I figure it can't hurt to try .

    When I'm working with two different raw data sources, I try and link them before creating my tables. I do this using VLOOKUP or a formula to connect the data.

    For example: if I need to pull current inventory, and current orders together, I will create a crosstab to condense all of the inventory by part number (we have inventory in more than one location so this step is necessary for me), then add a column to current orders that uses a formula to pull in the inventory for that part number. Then I can do a crosstab and have current inventory show with current orders for each part number.

    I hope that makes sense and helps.
    ~ Spoony

  3. #3
    Registered User
    Join Date
    06-20-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Making two crosstabs tables in one relational table.

    Makes total sense...but does not help

    Thanks

  4. #4
    Registered User
    Join Date
    08-28-2012
    Location
    Indiana
    MS-Off Ver
    It changes depending on the job.
    Posts
    36

    Re: Making two crosstabs tables in one relational table.

    Sorry!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1