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.