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
B 1 D 2 C 3 A 4