0
In Excel, I have 2 columns. I want to sort the second one in alphabetical order while keeping the (custom) order in the first one (think std::stable_sort where equality is based on the first column only). Example:
dsf k
www d
www a
azd q
azd e
azd b
should become
dsf k
www a
www d
azd b
azd e
azd q
The sorting wizard doesn't seem to have any "keep current order" option. I could define the custom order but I have more than a thousand different elements; that would be a real pain to do and this custom order can change at any time.