How to Sort Data in one column to match with other

[rahulrocks4504]

Hello
I have data in two columns.
I want to match the data in column B to that in column A

Desired Output:

Thanks

 

[MarcelBeug]

Well, in this example it's simply formula in B1: =A1 and copied downwards.

Seriously: will there be duplicates in A and/or B, will there be values in either A or B that do not exist in the other column, do you want only B-values that match with A-values or do you want to sort A and B together?