To get it in a single formula then use the below:-
Row / Col A Column
Row1 NAME
Row2 NDF
Row3 ABC
Row4 YJK
Row5 LDF
Row6 NTK
Row7 PMR
Row8 OTF
Row9 KQY
Row10 DFT
Row11 PKR
Copy and paste the below formula in B2 cell
=INDEX($A$2:$A$11,MATCH(SMALL(COUNTIF($A$2:$A$11,"<"&$A$2:$A$11),ROW(1:1)),COUNTIF($A$2:$A$11,"<"&$A$2:$A$11),0))
Place the cursor in B2 cell and press F2 and give Cntrl+Shift+Enter, since
it is an array formula.
Copy the B2 cell and paste it to the remaining cells of B Column depends
upon the A column data.
--
Remember to Click Yes, if this post helps!
--------------------
(Ms-Exl-Learner)
--------------------