Forum Discussion
Alex Buxton
Feb 05, 2019Copper Contributor
Excel Sorting Error
Hi all and thanks for looking. I have a spreadsheet that is an output from a database programme. It has 9 columns and 1000 rows roughly. There isn't data in all the cells. When I come sort o...
Nauthstar
Feb 06, 2019Iron Contributor
Likely non-contiguous blocks of data. Make sure you don't have any complete blank columns and select a single cell before sorting.
Alex Buxton
Feb 07, 2019Copper Contributor
Thanks for this.
What I noticed that quite a lot of rows had a single entry in a column but on the next row. So one entry equals two rows, so to speak, with all but 1 column accounting for the second row.
So what I did was delete the top empty cell in the column that had the extra space and this bumped all the entries to 1 row and I was then able to sort.