Power Query Question

Occasional Contributor


Hello Everyone,


Can someone help me to get the result through Power Query. I need final output as per the above snip shared. On the right, I have couple of tables with input data. 

6 Replies
Didn't understand the steps given in the link.
best response confirmed by ParasUdani (Occasional Contributor)



Which part were you unable to do?


  • query from each table
  • add a custom column to each "Custom" = 1
  • Merge "Dynamic List " (=first query)  with "Table" (=your second query) on "Custom"
    - Left join
    - expand "Table" column
    - delete custom helper columns
Thank you.


As variant

    Source = Category,
    #"Added Custom" = Table.AddColumn(Source, "Store", each Store[Store]),
    #"Expanded Store" = Table.ExpandListColumn(#"Added Custom", "Store"),
    #"Reordered Columns" = Table.ReorderColumns(#"Expanded Store",{"Store", "Category"})
    #"Reordered Columns"
Thank you