Forum Discussion
Power Query not sorting Properly (Excel 2013)
Hello all, I am new to these forums so forgive if I am doing anything wrong. I have come across a problem with Power Query in Excel 2013. I am importing from a Table in a different Excel workbook, ...
Hi Sergei,
Thanks a lot for your comments!
I have tha same issue of Peter. The sorting look correct in Query Editor Preview, however when I Load to table the sorting looks completely different
I noticed that sorting follows the ASCII codes, which is different from Excel's sorting behavior. Does it explain the unexpected sorting result?