I have been extensively using Power Query at work to automate pulling data from 20 different excel files, access data base and other sources. What I really like about Power Query is I can reorder the...
While this issue seems to be about making column re-ordering easier in the UI, it would also be nice if the Table.ReorderColumns command had a way to move a column to the first or last without naming all of the other columns. In my scenario I have a pivot table with a variable number of columns and then I am adding a column to it. I want the new column to be somewhere on the left hand side of the table before all of the pivot columns. The ReorderColumns command won't consistently move the column to the new column where I want it unless I name all of the pivot columns (that have variable names). Commands like MoveFirst, MoveLast, MoveBefore, MoveAfter, would be helpful.
