Hello, dear friends!

My question: I have a bulk of data in column A. I need to make a list of data in column B in the following way

A1 = Anna
A2 = Inga
A3 = Inga
A4 = Peter
A6 = Anna
A7 = Alex

I want to know what names are used (without finding out how many times it appears in column A) and to get a table in B column like this:

B1 = Anna
B2 = Inga
B3 = Peter
B4 = Alex

thank you very much.