Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an excel sheet that looks similar to the following:

enter image description here

How can I remove the rows that do not have anything in their columns, so for instance the final result would be:

enter image description here

Any help would be much appreciated, thanks! And on a side note, the actual excel sheet has several hundred columns and rows, which is why I did not just go through and manually remove them (I am not the person that created the sheet, am working with something that someone else had provided)

share|improve this question
3  
Couldn't you just sort the rows, and then remove all the empty ones at once? Once that's done, re-sort according to the index column and re-index. –  slhck Mar 18 '13 at 7:17
add comment

2 Answers

up vote 2 down vote accepted

If your data sheet looks exactly as your screenshot does (The rows that contain blanks are empty across all columns), you can try these steps to get rid of the blank rows.

  1. Highlight a column that contains blanks. enter image description here
  2. Press Ctrl + G.
  3. Click Special.
  4. Select Blanks. Click Ok.
    enter image description here
  5. To start deleting the rows, press Ctrl + - .
  6. Select Entire Row.
share|improve this answer
    
worked perfectly, thanks! –  lacrosse1991 Mar 24 '13 at 7:36
add comment

enter image description here

In Excel all row data are separated by cells, nultiple cells in one single row make a meaning full record (Data). So to clear up, irrelevant link first you need to define all rows and columns (you can remove this rows and columns after completion of your task. Steps:

  1. Place cursor at A1
  2. Insert row
  3. Place cursor at A1
  4. Insert column
  5. Place cursor at A1 and type "Sr#" as column name
  6. Type 1,2,3.... upto the end of row. (You can just type 1 in A2, and type 2 in A3 then select A1:A2 and drag the cells to fill the series.
  7. Do the same for columns (1,2,3....)
  8. Now all of your rows and columns have numeric names.
  9. Now select all data and sort it by Column C (That is column name 2)
  10. You will get all your filled rows upper and all blank rows below.
  11. Delete all blank rows including all Sr. no data and column 1 data.
  12. Now again select all data and sort by column Sr.#
  13. THats all !!

And you will get your data.

enter image description here

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.