Figure A We’ll use Power Query to combine the address elements into a single cell. Getting the data into Power Query requires following just a few steps. 1. Click anywhere inside the Excel Table. 2.

Excel might be the world's most widely used programming language; Microsoft is on a journey to turn it into a better and more powerful programming language, without losing what makes it Excel.