combining rows of data into one row

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.
 
G

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top