Forum Discussion
Solved
Generate list from two queries without relationship
I have two tables in excel (Players and Games) with no common fields between them and want to generate a list with each player having all games listed. It is easy using a pivot in excel or quey in Ac...
In your player table add the following...
#"Add gamesTable Column" = Table.AddColumn(#"Previous Step", "gamesTable", each gamesTable),
#"Expanded gamesTable" = Table.ExpandTableColumn(#"Add gamesTable Column", "gamesTable", {"Games", "Date"}, {"Games", "Date"})
