Extract unique values on each column separately

  • Hi,

    I want to extract unique values in a column separately ... I can do that easy with remove duplicates. But unfortunately I have 990 columns!

    How i can do it for all columns more quick ?

    In attach : picture table_1 how it looks the table initially

    and in picture table_2 how it should be after apply a formula or VBA code.

    Thank you.

  • I found the code somewhere else :

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!