Occasional Visitor

How do I double the contents of rows in Excel, if I have several rows and I want each row to appear twice in a row?

2 Replies


The following suggestion ... as far as I could understand your concern.

In a Sheet1, write in cell A1:

= INDEX (Table1! A: A, (ROW (A1) +1) / 2)

and copy that down as far as necessary.

In B1 then:

= INDEX (Table1! B: B, (ROW (A1) +1) / 2)

and in C1:

= INDEX (Table1! C: C, (ROW (A1) +1) / 2)


If you allow, for the next time you want to ask a question (which will be very welcome) I would recommend you to insert a file (without sensitive data), as well as Excel version and operating system. In this way, you can come up with a tailor-made solution proposal / offer much more precisely and more quickly.


Thank you for your understanding and patience.


I also wish you success with Excel.


Hope I was able to help you with this info.




I know I don't know anything (Socrates)



Same basic method as Niko, just with changed absolute/relative references and used offset to make it one easily draggable formula. Try this formula in a separate sheet A1. (assuming your data is in Sheet1 and starts in A1).


Just drag right for as many columns as you need to copy and then drag down.