I realize this is likely a dumb question but for the life of me I cannot seem to find the answer.....
I am trying to take Column A and paste it into column B but with one catch I need to reverse the numbers. Meaning I need line 100 to be line 1 and line 99 to be line 2. Of course when I do in line b1 =a100 that is nice however when I copy and paste that into line b2 it is 101 and I want it to be 99.
this is just an example in reality i have over 1000 lines to move and dont really wanna do it manually ....

Any ideas? Seems there should be a way to accomplish this...

thank you in advance for any help !