How to extract unique ids in order to pivot them (not removing them)

[DIFF1]

Hello friends,

I have a question. Will be very grateful if someone can help me.

I need to have a unique count of order IDs in column B.

For example, column A has 5 S01-1217855-6422013 and later 2 S01-3290782-2346839 etc. They are duplicates but I cannot remove those duplicates because they are connected to an another criterion (ASIN number, they differ for duplicates).

At the end, I want to pivot data based on the unique count of order id and not based on the line level (with duplicates).

Does anyone know?

I strongly appreciate your time.