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
Rohit Bhalotia (CA) (52 Points)
07 June 2008Friends...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
ranjeet
(student)
(20 Points)
Replied 07 June 2008
Use Auto filter, then select blanck cells and delete them. you will get desired result.
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
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
guru santhanam
(Chartered Accountant)
(97 Points)
Replied 10 June 2008
Hi Rohit,
Excel will select the blank rows also provided you select all the rows (including blank rows) till the end and then put auto filter.
I suggest u select entire column (eg: A to D) and then try auto filter.....then even if A column contains blank rows...it ll get selected.....
Sorting, Autofilter are the best ways to remove blank rows.
Regards,
gurusanthanam
Live class on PF & ESI Enrollment & Returns Filing(with recording)
CAclubindia
