Can you please help me in below problem?
How to insert blank row in a given data in excel. My data is as follows:
1. 1st insert a blank column (e.g. Column A) beside any data column then write 1,2,3, so on in "Column A" .
2. Then copy only those cells where 1,2,3 etc is written and paste down at last row of Column A then go to SORT option and sort with "Column A"
3. Then delete "Column A"
Condition: Paste cells 1,2,3 etc as per requirement of ROW. If you need more ROWS then paste again same cells at last row.
I hope this will be helpful........Kuldeep Singh 10 Dec 2017 0 0