+ Reply to Thread
Results 1 to 3 of 3

Power Query Combine

  1. #1
    Registered User
    Join Date
    05-05-2020
    Location
    Wisconsin
    MS-Off Ver
    365
    Posts
    2

    Power Query Combine

    Any help would be appreciated.

    I need to combine two table that have no common ID

    Table1 is a list of PN

    PN1
    PN2
    PN3

    Table2 is a list of Types

    SO
    WO
    NET

    I need to combine these two table to get an output of two columns

    PN1 SO
    PN1 WO
    PN1 NET
    PN2 SO
    PN2 WO
    PN2 Net
    PN3 SO
    PN3 WO
    PN3 NET

    I can do this in access by creating a query with the two tables, but with no join. I want to stay in excel if possible.

    HELP!
    Attached Files Attached Files

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,706

    Re: Power Query Combine

    I am far from being an expert on PQ but, you could try something like below (to ape the cartesian join)

    so, basically imported both tables, then added custom column to 2 table (set to Type) and Expanded it.

    Please Login or Register  to view this content.
    Last edited by XLent; 05-05-2020 at 10:01 AM.

  3. #3
    Registered User
    Join Date
    05-05-2020
    Location
    Wisconsin
    MS-Off Ver
    365
    Posts
    2

    Re: Power Query Combine

    Wow, didn't know it had a name, Cartesian Join!!! Plenty of stuff on youtube about it. THANKS!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Power Query, Problem with combine inconsistent column files in a folder
    By Eric Tsang in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 02-11-2021, 07:17 PM
  2. [SOLVED] Power Query: Combine records with deliminter
    By misty15 in forum Office 365
    Replies: 4
    Last Post: 09-17-2019, 04:34 PM
  3. Power Query: Combine and Transform from folder
    By LUKE92 in forum Excel General
    Replies: 13
    Last Post: 06-26-2019, 12:34 AM
  4. [SOLVED] I do not have a combine option - Power Query
    By callumlmcgrath in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-08-2019, 06:24 AM
  5. Power Query: combine sheets from different workbook
    By erica.ho56458 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2018, 02:28 AM
  6. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  7. Replies: 1
    Last Post: 11-06-2017, 12:42 AM

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