Sorting rows with an "x" in them

Scottisimo Sorting a column that contains truly blank cells (i.e. cells with nothing in it) proves to be tricky as these blanks will always be placed last. No matter which sort order you select.

To overcome this you would need to put an empty string in each of the cells in that column first and then over-write these with an X and then, every now and then, sort the table in ascending order of that column. Easiest done when you use a structured table and enter a formula like ="" (i.e. the equal sign and two regular quotation marks) in column A. This will auto-fill the entire column with the empty string formula. When you insert a row, the formula will be copied in automatically.

If you want all to be done automatic, as soon as you have entered an X in column A, you'll need VBA (a macro). Not my kind of thing, I'm afraid.