Sorting with Space Issue in Excel (Filtering)

Hi:

In the attached I have data that I am unable to sort in order.

I tried to sort using the filter and the "A/Z" function. I need the data in Column A to be sorted in order without any empty cells in between each row.

Any help is appreciated.

Thanks.

I had no problems doing that.

I just tried again and had no success.

I know its probably simple.. but can you walk me through step by step what you did?

Thanks.

I just selected all the data starting from the bottom

then I clicked on A-z