I have a column formatted as text, I want to reverse the numbers around
a1 1 a1 5
a2 2 a2 4
a3 3 will look like this a3 3
a4 4 a4 2
a5 5 a5 1
Take #5 and move it up to row a1 #4 move to row a2 #3 stays put, #2 move it
to a4 and #1 move to a5. Can this be done with Excel. I need it simple.
Thanks Bob