Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • How to remove Blank Rows in Google Spreadsheet?

    • 0
    • 0
    • 0
    • 1
    • 0
    • 0
    • 0
    • 1.03k
    Answer it

    Hi,

    While working on Google spreadsheet, I need to delete the blank rows from my sheet, as shown in screenshot below.


    alt text


    In the above screenshot in column B, I have Names and after each Name there is an empty row, I want no empty row in between names, so please provide me the formula or the way to do this, I do not want to do this one by one as it will be time consuming for big data.

 1 Answer(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: