![how to add columns in an excel query table how to add columns in an excel query table](https://d13ot9o61jdzpp.cloudfront.net/images/Power_Query_Add_Column_from_Example.png)
You want to retain permanent notes against some rows, but you have no way of knowing if they're going to be there next time you refresh the query (presumably). The issue here is that the results of this query might change - more rows might be added, rows might be removed, that kind of thing. Suppose you have your query, which is currently loading onto a in your workbook: Is there a way for me to set up this "Notes" column such that I can achieve all my goals described above? When I add the "Notes" column to the table, although this solves the sorting problem, another problem arises, namely, that when I refresh the query, the cells in the "Notes" column get reordered and no longer match up with their original rows. When I keep the "Notes" column separate, I am unable to sort the table and the column together (or at least I haven't found a way to be able to do this). However, I run into problems both when I keep the "Notes" column separate from the table and when I make it part of the table. I am also interesting in being able to sort the table and the "Notes" column together - i.e., maintaining the match between each cell in the "Notes" column and its matching row - and in maintaining this match when refreshing the query. I am interested in adding a "Notes" column to the end of the table to be able to add information to each row.
![how to add columns in an excel query table how to add columns in an excel query table](https://trumpexcel.com/wp-content/uploads/2018/06/Merge-Tables-using-Power-Query-Table-2-3.png)
In my Excel spreadsheet, I have a table with data queried from another workbook.