Forum Discussion
Copy State Abbreviations in One Column Multiple Times
Hello, I have a list of state abbreviations and each abbreviation needs to be copied a certain number of times in one column. The attached photo is an sample of what I am trying to do, with a list of...
Assuming your list starts from A1
=INDEX(A:A,INT((ROW()-1)/7)+1)and copy it down. If another rows, for example list if states starts from row #10 and you'd like to copy it with repeating into another column starting from row #15, when
=INDEX(A:A,INT((ROW()-15)/7)+10)and drag down. Sure better not to hardcode constants.