Go Ad-Free on CAclubindia with Daily Mobile Updates. Subscribe Now!

Excel query

07 June 2008

Friends...need a help..I have a worksheet in which data is compiled but it is alternate rows i.e alternate rows are blank..my requirement to compile data in adjecent rows i.e. blank rows is to be deleted

Thanks

Reply
Follow
Share

7 Replies

ranjeet (student) (20 Points)
Replied 07 June 2008

Use Auto filter, then select blanck cells and delete them. you will get desired result.

Upgrade to CAclubindia Pro. Subscribe Now!

Krishna Rao (Service) (31 Points)
Replied 07 June 2008

in case if one column is having a serial number / date etc. in ascending / descending order. you can sort the entire data and all blank rows will go down.

CA. Nitin Agrawal (Chartered Accountants) (1066 Points)
Replied 07 June 2008

Mr Rohit Solution suggest by Mr. Ranjjet will not be helpful in case of ROW BALNK CELL REMOVAL If u done this the data in other row will also deleted The best way to sove the problem is to use the logical function "IF" Ask for further enquiry Regards Nitin Agrawal cell: 9893791917 email:nagrawal.raipur @ gmail.com

Neha L. Jain (PCC student) (90 Points)
Replied 09 June 2008

I think u should use Autofilter option & then select the "blanks" and delete the entire rows. U can then Copy the compiled data as required in a new worksheet by selecting paste special, values. I think this would solve your purpose. Try It !

Rohit Bhalotia (CA) (52 Points)
Replied 10 June 2008

dear friends.. Thanks 4 writing. filter option won't work as in filter fuction, if a row is complete blank then it won't take next row data.. so in this way blank rows cant be deleted