Excel

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

@Rf150776 

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.

 

 

Nikolino

I know I don't know anything (Socrates)

 

@Rf150776 

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.

 

=OFFSET(Sheet1!A$1,INT((ROWS($A$1:A1)-1)/2),)