Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2982480%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2982480%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHow%20do%20I%20double%20the%20contents%20of%20rows%20in%20Excel%2C%20if%20I%20have%20several%20rows%20and%20I%20want%20each%20row%20to%20appear%20twice%20in%20a%20row%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2982480%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2987028%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2987028%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1223272%22%20target%3D%22_blank%22%3E%40Rf150776%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20following%20suggestion%20...%20as%20far%20as%20I%20could%20understand%20your%20concern.%3C%2FP%3E%3CP%3EIn%20a%20Sheet1%2C%20write%20in%20cell%20A1%3A%3C%2FP%3E%3CP%3E%3D%20INDEX%20(Table1!%20A%3A%20A%2C%20(ROW%20(A1)%20%2B1)%20%2F%202)%3C%2FP%3E%3CP%3Eand%20copy%20that%20down%20as%20far%20as%20necessary.%3C%2FP%3E%3CP%3EIn%20B1%20then%3A%3C%2FP%3E%3CP%3E%3D%20INDEX%20(Table1!%20B%3A%20B%2C%20(ROW%20(A1)%20%2B1)%20%2F%202)%3C%2FP%3E%3CP%3Eand%20in%20C1%3A%3C%2FP%3E%3CP%3E%3D%20INDEX%20(Table1!%20C%3A%20C%2C%20(ROW%20(A1)%20%2B1)%20%2F%202)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20allow%2C%20for%20the%20next%20time%20you%20want%20to%20ask%20a%20question%20(which%20will%20be%20very%20welcome)%20I%20would%20recommend%20you%20to%20insert%20a%20file%20(without%20sensitive%20data)%2C%20as%20well%20as%20Excel%20version%20and%20operating%20system.%20In%20this%20way%2C%20you%20can%20come%20up%20with%20a%20tailor-made%20solution%20proposal%20%2F%20offer%20much%20more%20precisely%20and%20more%20quickly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20wish%20you%20success%20with%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
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),)