Insert blank rows on missing of numeric serial

By ajmalhussain16 ·
Respected sir,

I want to insert blank rows on missing of numeric serial. Like wise

Ser # Name
1 Asghar
2 Ali
4 Shafi
8 Navid
10 Karim

As mentioned above there is missing of serial numbers 3,5,6,7,9. My plea is that MS Excel should automatically generate blank row (Using formulas or Code) in lieu of missing serials.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums