VBA compact attributes in less columns

  • Hi everyone. My first post here but used as inspiration many times.

    In the attached file, the original data is on A1:F14 and the desired outcome in K1:M14. I`m looking to use less columns to show attributes for each ID on column A. The single restriction is that the unique strings must be placed on the same column, whatever that is.
    Does not matter if the outcome is in the same sheet or a new one.

    Any idea would be appreciated.
    Thank you!

Participate now!

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