I want my data as shown in the Power Query Editor to load exactly as shown. After I select Close & Load, the data dumps into Excel in a different way, as if maybe it is sorted or something. Why isn't my data loading into Excel exactly the way it is shown in the Power Query Editor?
It is default behavior. The preview window only shows the first 1000 rows (give or take, it depends on a few things). When having evaluated all data the data loaded can come out in a different way.
Adding an index column might help, but it's also expensive.
That is really surprising. Why would they design Power Query this way? Why not render the data the way it is in the source files? This really complicates things.
How do you add an index column? What do you mean when you say it's expensive?