Forum Discussion
Self-referencing Columns Won't Stay Put Upon Power Query Refresh
I'm using a large google sheet as my source table and pulling the raw data into an excel spreadsheet via power query. From there, I have added multiple columns to the table that reference the columns...
Hi Ctisa87,
There is a command in PQ Table.ReorderColumns() which deals with this.
Just manually (using your mouse) move the colunms into positions that you prefer them to be and they should fall into places in the output.
Cheers,
John
Does this solution work for columns that are not part of the power query? For instance, the columns that move are the ones I add in excel after the power query has already been performed.