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 on let's say column C, all the columns apart from column F. Column F creates a lot of empty cells at the top of the sorted data.
I note that for column F most of the date is on row two of what would normally be a single row of data.
Does anyone know how I can work around this scenario with least effort? I just did a quick test and moved the second rows in line with the first rows and the sort worked as it should.
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.