When working with address data, you may encounter situations where you need to merge multiple columns, such as address, town, and postcode, into a single column. Power Query makes this task a breeze.

One of the first things I learned about Power Query—and a rule I still follow religiously today—is to not select a column and delete it. To build a truly resilient dashboard, you must instead tell the ...