there is a sort formula you can use to sort your data without doing it manually. You can also do a counter to enumerate your non-blank data...which will lead to composing a solid list without blank spaces. Both require naming the range to make it dynamic. Would you like a sample? Or does this make sense to you?