Power Query Question

[ParasUdani]

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. 

[#2]

I just answered a very similar question on /r/excel

https://www.reddit.com/r/excel/comments/pghbqm/power_query_adding_a_dynamic_list_to_a_table_of/

[#3]

Didn't understand the steps given in the link.

[#4 · Accepted solution]

@ParasUdani 

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

[#5]

Thank you.

[#6]

@ParasUdani 

As variant

let
    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"})
in
    #"Reordered Columns"

[#7]

Thank you