I refreshed my query and now it has jumped a few columns over to the right. Whats going on?
This is usually an indication that you have more than one query occupying the same space. When you refresh the data, Excel is pushing second query over to make room for the data in the first query. To resolve this issue, you need to delete the older query or queries. Heres how: Select the query from the Name Box drop-down list: Right-click inside the selected area and pick Delete from the popup menu. If you are working on a copy of the spreadsheet from before the column shift, then pick Shift cells up when prompted, otherwise pick Shift cells left. After that, its a good idea to delete any data from below the top row of functions and refresh the workbook.
