How do I combine multiple rows with like data in Excel?

C

CAW@NG&G

I don’t know what this would be called or what formula to use and would
greatly appreciate any help I can get.

I would like to take the example table below and get the following results.
First Last Address Previous Employer
Steve Smith 166 Home St 4

I would like one row with the like data listed and a count if possible of
the non like data.
First Last Address Previous Employer
Steve Smith 166 Home St ABC Inc
Steve Smith 166 Home St #1 Times
Steve Smith 166 Home St Any Work
Steve Smith 166 Home St Work Now
 
C

CAW@NG&G

I tried a pivot table function but I cannot get multiple columns to show. I
think a VB formula will give me the data that I’m looking for but I just
don’t know all the command lines.

First Last Address Previous Employer
Steve Smith 166 Home St 4
 
Top