Organising rows so tat all Blank rows appear first

[Deano478]

Hi All Happy Friday,

This is a bit of an odd one but Essentially I have data I'm getting in from MS Forms and I have an excel sheet to use as a way of marking of requests as being complete when there done.

Is there a way I can have all the blank rows appear first so have all the 1's following the blanks for easier readability?

Here is a dummy sample:

Request Complete (Mark with a 1)	ID
1	259
1	260
1	261
1	262
1	263
	264
1	265
	266
1	267
	268
	269
	270
	271
	272
	273

[DavidSkaife · Accepted solution]

Hi @Deano478 

You can use the Sort tool, and sort ascending on the Request Complete field:

[Deano478]

@DavidSkaife Wow I was really over thinking when it was simple many thanks