SOLVED

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

Copper 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
                 etc.

2 Replies
best response confirmed by Wromkes (Copper Contributor)
Solution

@Wromkes 

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)

1 best response

Accepted Solutions
best response confirmed by Wromkes (Copper Contributor)
Solution

@Wromkes 

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)

View solution in original post