Thanks for the reply. Actually I want unique value next by next (no blank row). Your solution brings blank row. Is there any way to get unique record in each row ignoring blank row using formula (not by sorting or anything else)? It will be look like below:

Present Solution after I drag down the formula: (Suppose 3 unique value there in my data)

Col. B

Row 1 = unique value
Row 2 = blank
Row 3 = unique value
Row 4 = blank
Row 5 = unique value


Required Solution:
Col. B (no blank row there)

Row 1 = unique value
Row 2 = unique value
Row 3 = unique value