How to delete duplicate entries in excel columns

All i want is , how to delete the duplicate rows in Column B of input tab, The output should looks like 2nd tab i.e output should look like tab(yellow color is not compulsry, its just used for reference).

Please Login or Register  to view this content.

i hope this help.

well i m not getting like how to use pivot table, can somebody have some idea of any formulae or macro etc...

@meetvivek72
Do you try the macro that i send you?

thanks @ wenqq3, it helped me , really working fiine..................