• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Adding blank rows in between available in one shot

S

senthilkumar_rm

Member
Dear Experts,


I have the data as below


Column A

Row 1 23

Row 2 45

Row 3 46

...


Like i have data upto row # 566 - I Need to add a blank row in between each row ,

suggest me some short cut to add the blank rows in single one shot / easy


Thanks
 
It is very simple

--Insert a temporary column say (ColA)next to your data

--In cell A1 enter 1, in A2 enter A2..Autofill upto 566

--Copy & paste A1:A566 from A567

--Now sort ColA ascending

--Delete ColA

The alternative blank rows are inserted.


If you dont want to sort. You will need the macros.
 
Good day senthilkumar_rm


This link has both formula and vba examples


http://chandoo.org/forums/topic/inserting-a-blank-row-after-every-alternate-item-of-a-list
 
You must log in or register to reply here.
Back
Top