Power Query and Excel don't agree on sorting?

by mll   Last Updated June 13, 2019 09:01 AM

Take a table that has the following records

Field A
|
a

If I sort it with Excel, I get the pipe characterbefore the "a"

Field A
|
a

Now, if I sort it with Power Query, I get

Field A
a
|

That can be a problem in some situations (for instance, i'm using the double vlookup trick for performance reason, and it gets messed by this discrepancy).

Here's a screenshot that illustrates the problem (it's actually wider than what I described above, because they also don't agree on the sorting of empty cells): screenshot. And here's a link to this sample workbook.

So my questions are: is that a bug or a "feature"? And most of all, is there a way to make Power Query sort like Excel does?



Related Questions


Updated December 08, 2015 09:00 AM

Updated January 15, 2019 18:01 PM

Updated April 28, 2017 18:01 PM

Updated May 25, 2018 23:01 PM

Updated December 17, 2018 15:01 PM