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.

1. Click anywhere inside the Excel Table that you want to load into Power Query. 2. Click the Data tab. 3. In the Get & Transform Data group, click From Table/Range.