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...
dennisr
Advocate II
Advocate II'I agree that there should be a dialog that would allow moving/ordering the columns. Maybe the "Choose Columns" could have two panes - drag from left (all columns) to right (display columns), and the right side would have ability to order with up/down and click/drag. However, I've found a bit of a workaround for now: move just one column, and then manually edit the resulting expression which does list all the columns = Table.ReorderColumns(...
