Excel tip: How to use Get & Transform to merge columns

The Get and Transform feature of Excel 2016 sounds new, but some of you may know it by its old name, Power Query. You now get the data, and then you transform it, hence the new name.