Objective: To insert blank row after every line item in Excel (MIS Reporting)
Excel Technique used: “Dummy” Serial Number and SORT
Step 1: Create a new column (refer Yellow cell in Column G) and write 1 and 2
Step 2: Select both 1 and 2 and drag-down the cells jointly so that a series can be generated
Step 3: Copy the generated list and paste it once again below the original list
Step 4: Select the entire dataset
Step 5: Go to DATA tab – SORT button
Step 6: Sort the data based on the Column – “DUMMY Serial No.” –Smallest to Largest
Step 7: Delete Column G and format the table with Borders
To read CA. Rishabh Pugalia’s other articles on Excel tricks on CAClubindia.com, click here
[/articles/article_display_list_by_member.asp?member_id=997936]
To attend his LIVE workshop in Kolkata or Mumbai, Click here
To subscribe to CA. Rishabh Pugalia’s Online Training Program at CAClubinda.com, click here:
[www.caclubindia.com/coaching/excel.asp]
CAclubindia
