Forum Discussion
Walt Bednarz
Nov 17, 2018Copper Contributor
Join two columns of data in a recursive manner
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-R...
Detlef_Lewin
Nov 17, 2018Silver Contributor
Hi
It's called a cross join.
- Walt BednarzNov 17, 2018Copper Contributor
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?
- Detlef_LewinNov 17, 2018Silver Contributor
I thought you were familiar with Get & Transform (Power Query).