Move data, consolidate on one row for multiple clients

Hi, I have a large spreadsheet of data and I need to consolidate multiple data points onto one row if the customer ID is the same. I've attached an example spreadsheet. Can anyone help with a macro?

Tab 1 shows the current data
Tab 2 shows what I'd like the end goal to look like.

I forgot to mention. Some clients may have up to 100 rows of data I need to consolidate into 1 row.

works but maybe slow with large data set

Please Login or Register  to view this content.

Kind regards
Leo

Brilliant, thank you very much.