To add an index column, run a simple query as follows: 1. Right-click Sales By Month in the Data pane, and choose Edit Query from the resulting submenu (Figure E). Figure E Run a query. 2.

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.