To insert row in every alternative row. Follow the steps:
- Insert one more column in last of the table. You can see in below image column is inserted in E.
Now fill the cells with running numbers begining with 1.
- Second step is to copy the Number in same column.
- Third step is, Filter the E column and arrange the numbers in Smallest to Largest format.
You can see that row are inserted alternatively. Now you can delete the last column.
Posted 3 years ago by CA Pulkit Sharma
No response yet, be first to reply.Your Reply:
You need to be logged in to reply.