One way is to Highlight all data you want sorted in both columns. Click
on Data then Sort. Set the sort order to Column B and select if you
have a header or not and tell it to sort. This should do what you
want.
Yes that worked well,
But I need to keep the original data in its original order and on another
sheet i need the same data in the sorted state. Any thoughts?