text1, text2, text3 to text1, text1, text2, text2, text3, text3

Question

I want to autofill texts in column A to B this way, how do I do this?text1&nbsp; &nbsp; |&nbsp; &nbsp; text1text2&nbsp; &nbsp; |&nbsp; &nbsp; text1text3&nbsp; &nbsp; |&nbsp; &nbsp; text2text4&nbsp; &nbsp; |&nbsp; &nbsp; text2text5&nbsp; &nbsp; |&nbsp; &nbsp; text3etc.&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; text3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;etc.

hansvogelaar · Accepted Answer

Wromkes&nbsp;
Enter text1 in A1, then fill down as far as you want.
Enter the following formula in B1, then fill down:
&nbsp;
=INDEX(A:A,(ROW()+1)/2)

Forum Discussion

text1, text2, text3 to text1, text1, text2, text2, text3, text3

Share

Resources