Question: how to copy and paste multiple rows multiple times in excel?
Answer: Start typing the same text in multiple columns. CTRL + Click each instance of the name. ...  Continue CTRL + Clicking the empty spaces the name will go. Once done, type the name one last time and press CTRL + Enter.