Forum Discussion
Power Query Preserve column sort/filter/layout
In Excel 2016, Version 1705 (Build 8201.2193), if I have a query from Get & Transform that is returned to the worksheet, it reorders the columns to match what is in the query editor every time I refr...
Just wanted to follow up on this query. Had anyone had any luck with resolving this? I’ve tried all the external data options and it seems like the button for “preserve column sort/layout” doesn’t do anything in Excel 365. It worked fine in Excel 2013 with PQ addin.