Forum Discussion
Solved
text1, text2, text3 to text1, text1, text2, text2, text3, text3
I want to autofill texts in column A to B this way, how do I do this? text1 | text1 text2 | text1 text3 | text2 text4 | text2 text5 | text3 etc. | text3 ...
Enter text1 in A1, then fill down as far as you want.
Enter the following formula in B1, then fill down:
=INDEX(A:A,(ROW()+1)/2)
Enter text1 in A1, then fill down as far as you want.
Enter the following formula in B1, then fill down:
=INDEX(A:A,(ROW()+1)/2)
Thank you HansVogelaar, it works!