Forum Discussion
How would *you* Align Two Tables in Excel?
I have a bunch of Excel videos out on YouTube that are generally well received. But recently, I've been getting hate mail from viewers of a video called "Align Two Tables". I made the video becau...
Power Query. No messing with formulas. No problems if new data gets added to the product table.
Create a connection to each of the two tables, then merge the two tables and extract the Sold column.
let
Source = Table.NestedJoin(Products,{"product"},SoldProducts,{"sold product"},"NewColumn",JoinKind.LeftOuter),
#"Expanded NewColumn" = Table.ExpandTableColumn(Source, "NewColumn", {"sold"}, {"sold"})
in
#"Expanded NewColumn"
No need to replace formulas with values. One click to refresh when new data is added.