Sep 03 2021 03:47 AM
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.
Sep 03 2021 04:41 AM
Sep 03 2021 05:20 AM
Solution
Which part were you unable to do?
Sep 03 2021 05:54 AM
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"
Sep 03 2021 05:20 AM
Solution
Which part were you unable to do?