Home

Join two columns of data in a recursive manner

Walt Bednarz
New Contributor

I have two columns that I want recursively joined.

 

Column 1: regions (KY, PA, MI)

Column 2: plant resources (Resource 1, Resource 2, Resource 3)

Column 3: company resources (KY-Resource 1, KY-Resource 2, KY-Resource 3, PA Resource 1...)

 

I expect to update add rows to columns 1 and 2. So would like Column 3 to update by adding the additional rows. I figured Get & Transform would be the way to do this, but can't seem to get that to work.

 

3 Replies

Hi

 

It's called a cross join.

 

Thank you. A couple of questions. Did you invoke that query through a command or did you have write a sql query in an editor? If it was through a command, where do I find the command in Excel 2016? 

I thought you were familiar with Get & Transform (Power Query).

 

View and Manage Queries in a Workbook (Power Query)

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies