Thank you for valuable ideas.....
it is very useful when we have small data...(like 50 or 100 line items....)
but if I have 1000 or 2000 line items so that time how I can sort it.....
Hui suggestion of getting unique values through advanced filter will be faster compared to my link method, as I had used formula, next putting values in cell will have to be macro.