Query1. Add 1 Row Between Each Name

This is the Query asked by Naren today...

Query: This is the name list, we have to insert 1 row between each Name 

 

 

 Step 1. Add serial no. in next column

 

 Step 2. Copy serial no. & paste in below row

 

 Step 3. Select entire data & Sort by Column B (Make sure 'My data has headers' is selected)

 

  

Output: Your output is ready, now you just need to remove serial no.s from Column B

 

 

Thanks for learning...