How to launch Power Query We’ll work with a simple Excel workbook, shown in Figure B, with six empty sheets. One of the sheets also has a named range, denoted by borders.

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.