Ok, you owe me now. I was laughing because of how ridiculously cool this tip is...and then my girlfriend asked me what I was laughing about...I fell down the cool ladder really hard
Thanks, Saved a lot of time for me, i had a data of 114 companies each with data from 1999 to 2014, and i had to add data for 2015 to 2020 for all 114 companies, means i had to add five rows 114 times. your techique saved my time