How do I sort a column according to ascending values in excel, while keeping the respective initial value in the other columns on the same row?
Column A shows the name of a subject. Column B shows a numerical value. I want to sort column B according to ascending value and keep the name of the subject attached. The name of the subject should stay linked to the value that was initially in the same row.
A 4
B 1
C 3
D 2
should become
B 1
D 2
C 3
A 4