combining rows of data into one row

  • Thread starter Thread starter Miskacee
  • Start date Start date
M

Miskacee

I have an employee ID and a field for Goals. CUrrently there are 2-20 goals
per employee ID. I am trying to combine the 2-20 goals into only one field
per employee id.

I know I concatinate it but can't figure out how to get say for example 2
rows of goals into one row.

Employee ID Goal
1111 Learn Excel
1111 Learn Access

I'd like to create the above to look like this:
Employee ID Goal
1111 Learn Excel; Learn Access

Thanks for any help you can provide.
 
A tiny trick. Say your real data starts in A2. In C2 enter:
=B2
In C3 enter:
=IF(A2=A1,C2 & ";" & B3,B3) and copy down
 
Back
Top