Hello,

So I am trying to do some excel gymnastics here and am having a lot of trouble sorting my data and figuring out how to even explain what it is I want to do. Basically, I have an original excel spreadsheet and a new excel spreadsheet, which is just an update of the original, containing more data. So the new spreadsheet has four more rows than the original. How do I take the new column and have it replace the original column, while maintaining the order?

I'll try and help visualize the issue here with a made-up example regarding number of universities in each state:

Original spreadsheet (2016):

FID State Universities

1 AL 124

2 KY 155

3 CA 166

4 NY 176

5 UT 98

New spreadsheet (2017):

State Universities

AL 127

MI 133

AZ 188

KY 150

CA 166

TN 145

NY 179

UT 98

So now we have 2017 data for the original states, and also for some new states. How do I take the data from the 2017 spreadsheet and merge it into the 2016 spreadsheet, while keeping the same order with reference to FID?

Thank you!