Split data into multiple columns

Hoping someone can help

So data looks like this

Client Tier
Alpha 1A
Beta 1A
Gamma 1B
AA 1C
BB 2A
CC 2B
DD 2C

I need this to put all the clients under each tier so

1A 1B 1C 2A 2B 2C
Alpha Gamma AA BB CC DD
Beta

There are thousands of names with numbers going from 1A to 5E

Thanks

I think you need to use an array formula - TRANSPOSE

I need all the client names under each tier

try the macro

worked like a charm.

Thanks, fancy explaining the macro when you get a second?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks, you have been brilliant.

Hopefully I can learn a bit from this

I am sure you will. until your next quest!!!