Reposition Cells in a Column based on another

[user03]

Looking for a way to reposition cells in one column based on another. A screenshot of the requirement is attached for reference.
Regards

 

[jerome drean]

you need to write a piece of code for that i think - i am not sure how to do that using excel function or pre built macros like ordering - let me know if you want the code

 

[user03]

you need to write a piece of code for that i think - i am not sure how to do that using excel function or pre built macros like ordering - let me know if you want the code

Certainly, will appreciate if you could share the code/xls
Regards