If the table is like the green table (that is, the rows are either completely empty or completely full) then try this:
1. Select A1:C8
3. Click on any of the little AutoFilter drop-down arrows and choose (Blanks) from near the bottom of the list.
4. Click in the top visible blank row and drag down to the bottom blank row.
5. Edit|Delete Row|OK
6. Data|Filter|AutoFilter to remove the filter mechanism.
You should be left with the non-blank rows.
If the table is like the blue table (that is, rows may be completely empty, completely full or partially full and you want to delete the rows that are completely empty) then try this:
1. Add a 'helper' column. Formula in D12 (copied down) is: =IF(COUNTA(A12:C12)=0,"Del","")
2. Select D11:D17
4. Filter column D to "Del" from the drop-down.
5. Again, click & Drag to select all visible rows.
6. Edit|Delete Row|OK
7. Data|Filter|AutoFilter to remove the filter mechanism.
You should be left with the required rows.
If neither of these is what you want, post back with more details.