Hi,
I have a list of text names in A2:A30 and would like to create a formula in column C that will put into cells in that column 13 instances of each item in A2:A30. For example, if A2 contains the word “Hello” and A3 has “Goodbye”, C1: C13 will contain “Hello” and C14 to C26 will contain “Goodbye”.
Can someone please suggest a formula that will accomplish this.
Thanks!
Bookmarks