I have a data file that needs a row added to it every year for the following year. Most of the fields just need to be copied down. I can't just copy it down normally because it will delete the data that's beneath it. I also want to avoid just copying each individual row and pasting it because it is a huge file.
rows 1-3 contains data X
rows 4-5 contains data Y
rows 6-10 contains data Z
I need to add a row for 2020 to each data X, Y, and Z. Is there a better way to do this than just individually copying and inserting rows?