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

New Contributor

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

2 Replies
best response confirmed by Wromkes (New Contributor)


Enter text1 in A1, then fill down as far as you want.

Enter the following formula in B1, then fill down: