I have recently been discovering the strength of Power Query (nick name M). It is a programming language that Microsoft has been introducing into Excel Power Pivot, Power BI and more.
Having a full blown programming language makes these tools all the more appealing. Here is a test example on how to union two tables together:
—
let
TableA = #table({“Name”, “Age”}, {{“John”,23},{“Mary”,25}}),
TableB = #table({“Name”, “Age”}, {{“Smith”,33},{“Ulrich”,35}}),
TableC = Table.Combine({TableA, TableB})
in
TableC
—