Combine unrelated columns in power query-CodePudding

I am trying to make a new table from columns in two unrelated tables. I need one column from table A to be the headers in the new table and one column to be a column in the new table. I attached a picture of what I am trying to achieve. This is just an example of the problem. The real problem is much larger and had a dynamic number of rows. I was thinking maybe store these two columns as lists and then somehow combine them?...not sure. Appreciate any feedback!

CodePudding user response：

There is probably 900 ways to do this. Offhand, try this

let
Columns= #table(Table1[Teams],{}),
Rows=Table.SelectColumns(Table2,"People"),
Combined = Rows & Columns
in Combined

Note, you have not provided any info on how to fill in the cells

Also, in 90% of the cases, you'd probably rather have the below set up where you can then add formulas to populate the cells before pivoting it back

using code:

let combined=Table.AddColumn(Table.SelectColumns(Table2,"People"),"Team", each Table1[Teams]),
#"Expanded Team" = Table.ExpandListColumn(combined, "Team")
in #"Expanded Team"