Results 1 to 3 of 3

Thread: Merge / Union ALL / combining tables???

  1. #1

    Question Merge / Union ALL / combining tables???

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I've got two tables, in one multiple distinct stores and in another one multiple distinct products.

    How do I get list with all the stores multiplied with the products? E.g.
    BranchID Product ID
    1 A
    1 B
    1 C
    2 A
    2 B
    2 C
    ... ...

    I've been looking for something like merge or union, but these answers only give me some kind of appended list, not a multiplied list.

    I can work with PowerPivot, if that makes it easier?


  2. #2

    Got the answer myself with PowerPivot... Thanks to my colleague.

    Here the quick solution:
    1: create another table with only one value called "link"
    2: add all three tables (stores, products, link-table) to the PowerPivot Model
    3: in the stores and product table, add a calculated field with the same value you used in the link-table (="link")
    3: create a relationship between stores and link and products and link
    4: Create a pivot and drag the stores and products into the row value, all values will be multiplied stores x products.

  3. #3
    Magician navic's Avatar
    Join Date
    Aug 2013
    Europe, Croatia
    Excel Version
    Excel 2013
    Quote Originally Posted by DatiDuke View Post
    Got the answer myself with PowerPivot... .
    Thank you for publishing solve of the a problem. Probably, this will your solution help others who have the same problem
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Tags for this Thread

Posting Permissions

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