I have 2 columns from an excel sheet that is in the order that i want to reorder my table into.
Example:
my current table A:
pat 2
ryan 33
bob 45
chris 6
My excel sheet has the correct sequence:
pat 33
ryan 6
bob 2
chris 45
How can i update my table A so that it matches my excel sheet? Do I have to update each individual line because i actually have 100s of these to update?
Example:
my current table A:
pat 2
ryan 33
bob 45
chris 6
My excel sheet has the correct sequence:
pat 33
ryan 6
bob 2
chris 45
How can i update my table A so that it matches my excel sheet? Do I have to update each individual line because i actually have 100s of these to update?