Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • How to remove Blank Rows in Google Spreadsheet?

    @sachin.joshi
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 1
    • 0
    • 0
    • 0
    • 1.42k
    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.

    Excel delete rows Google spreadsheet
    Answer it

 1 Answer(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           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: