Remove the multiple Blank rows the workbook sheet

[AmitSingh]

Hi All

Need help to remove the blank rows from the workbook sheet.

I have highlighted the column (yellow) based on which the blank rows to be deleted, means row of cells which don't have the value needs to be deleted.

I have attached the two workbook, 1st workbook is the file where changes needs to be done.
2nd workbook is output file, where desired output i have placed which done by manually.

I tried but didn't get the desired output.

Any help is appreciated as this little urgent. Thanks in advance.

Thank you!!

Warm Regards,
Amit Singh

 

[AmitSingh]

Hi All,

Can anyone solve this query as still i didn't get any solution.

Please let me if you require any other information.

Thank you!!

Warm Regards,
Amit

 

[ANKUSHRS1]

Information is not clear.
We haven't any blank row.

 

[AmitSingh]

Thanks for asking the query over this.

If you see my attachment, then you will find that from range column AD to BA, if we don't find any value between above mentioned range then delete the entire rows.

Hope i have clear your query and do let me know if you have any other query.

Thank you!!

Warm Regards,
Amit Singh