Combining multi-rowed data into 1 row

I work for an insurance company and need to consolidate some info. I have a report that lists a client and their type of insurance coverage. The problem is that there is only 1 coverage per line and most clients have multiple types of coverage.

I want to combine the coverages to 1 line so the client is only listed once and all their coverages is listed behind them. Below is a generic breakdown os the info.

Any suggestions on how to get started is very welcome.

2 columns of data < client - col A, coverage - col B > , like below
A B
A C
A D
E F
G H

If Cell A1 = A2, than copy cell B2 to C1 and delete row 2. Leaving the below
A B C
A D
E F
G H

Then repeat, IF Cell A1 = A2, than copy B2 to C1, unless C1 is not empty, then copy to D1 and delete row 2. Resulting in
A B C D
E F
G H

Repeat once again, If Cell A1 = A2, copy ... if not the same compare the next 2 set of rows.

Mate, very confusing. Post some real data and try to explain yourself better. That may assist in getting someone to help you

You can use this code to obtain what you need

Please Login or Register  to view this content.

I hope it can help you.

Regards,
Antonio

It is a bit confusing, sorry about that Mallycat.

I would give some more info, but antoka05 hit the nail on the head. The macro worked perfectly.

Thanks for the help, have a good one

Cheers