How can I collate all results of the same ID in a cell.

[shrek28]

Hi Everyone,

Need a formula on how will I get all Department names of the same ID to be displayed in a single cell per ID separated by semi colon. See attached file.

Thanks,
Shrek28

[zbor]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-gene...64#post3322764

Thread Closed.