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.