Results 1 to 5 of 5

Cartesian product / Cross join of two tables (possible solution with Power Query)

Threaded View

  1. 04-18-2016, 12:25 PM #1
    p3rlend
    p3rlend is offline
    Registered User
    Join Date
    06-19-2015
    Location
    Oslo
    MS-Off Ver
    2016
    Posts
    21

    Cartesian product / Cross join of two tables (possible solution with Power Query)

    I am wondering if it is possible to generate a third table from two tables which is the Cartesian product of the two. The attached Excel file illustrates my issue.

    Thanks in adavance!
    Attached Files Attached Files
    Last edited by p3rlend; 04-19-2016 at 07:33 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort Aphabetically 2 tables according to 1 columm (name of product)
    By fleyd in forum Excel General
    Replies: 3
    Last Post: 07-20-2015, 04:32 AM
  2. [SOLVED] Advanced Sum Product/SUMIF with multiple tables
    By pookyman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2014, 08:38 PM
  3. Cartesian Macro help!
    By katich in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-15-2014, 08:57 AM
  4. Transfer Data to separate tables based two variables (site and product)
    By yunesm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2010, 09:47 PM
  5. Product Analysis in Pivot Tables
    By pensworth in forum Excel General
    Replies: 7
    Last Post: 03-24-2009, 11:10 AM
  6. [SOLVED] Cartesian chart
    By Zekni in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-13-2006, 08:15 PM
  7. Product Function in Pivot Tables from Multiple Consolidation Range
    By bbishop222 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-22-2005, 01:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1