How can I separate rows to the bottom of the page with missing inf
 

I am still some what new to these Data Sheets and the different types of
functions. Let me show by example what I am trying to do.

A B C D E
1DVD MOVIE 16292 14.98 2140497 2140497
2DVD MOVIE 28264 14.98 2133826 2133826
3DVD MOVIE 56428 14.98 2114870
4DVD MOVIE 75638 14.98 2114869
5DVD MOVIE 35482 14.98 2111693 2111693
6DVD MOVIE 18792 14.98 2148557
7DVD MOVIE 27865 14.98 2133826 2133826

Basically I would like to move rows 3,4,6 to the bottom of the list because
they are missing the information in column F. Like I said I am still
somewhat new on all the features Excel can do and would like any help that
you can provide. Thanks in Advance.

Select the table.
Data menu - Sort
Sort by Column F, descending order.

"Mcobra41" wrote:

I am still some what new to these Data Sheets and the different types of
functions. Let me show by example what I am trying to do.

A B C D E
1DVD MOVIE 16292 14.98 2140497 2140497
2DVD MOVIE 28264 14.98 2133826 2133826
3DVD MOVIE 56428 14.98 2114870
4DVD MOVIE 75638 14.98 2114869
5DVD MOVIE 35482 14.98 2111693 2111693
6DVD MOVIE 18792 14.98 2148557
7DVD MOVIE 27865 14.98 2133826 2133826

Basically I would like to move rows 3,4,6 to the bottom of the list because
they are missing the information in column F. Like I said I am still
somewhat new on all the features Excel can do and would like any help that
you can provide. Thanks in Advance.

Thanks alot that worked great! :)

"Tee" wrote:

Select the table.
Data menu - Sort
Sort by Column F, descending order.

"Mcobra41" wrote:

I am still some what new to these Data Sheets and the different types of
functions. Let me show by example what I am trying to do.

A B C D E
1DVD MOVIE 16292 14.98 2140497 2140497
2DVD MOVIE 28264 14.98 2133826 2133826
3DVD MOVIE 56428 14.98 2114870
4DVD MOVIE 75638 14.98 2114869
5DVD MOVIE 35482 14.98 2111693 2111693
6DVD MOVIE 18792 14.98 2148557
7DVD MOVIE 27865 14.98 2133826 2133826

Basically I would like to move rows 3,4,6 to the bottom of the list because
they are missing the information in column F. Like I said I am still
somewhat new on all the features Excel can do and would like any help that
you can provide. Thanks in Advance.