Jun 09 2022 12:30 AM
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
etc.
Jun 09 2022 11:28 AM
SolutionEnter 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)
Jun 12 2022 11:58 PM
Thank you @Hans Vogelaar, it works!
Jun 09 2022 11:28 AM
SolutionEnter 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)