Merge Columns into One Row, Separated by Semicolon, Dependent on A Different Column

Hi!
I am an Excel beginner so while familiar with the idea of formulas I am not sure if this is something that is possible to do. Specifically, I have a few columns of keywords and Speciality/Area of Expertise for authors - the author names are First Name: Column B, Last Name, Middle Name, Column C, and Last Name Column D. The Keywords and Speciality/Area of Expertise are filtered in Column O, and the answer is in Column P.

My problem is that each Keyword and each Speciality/Area of Expertise is listed individually in multiple rows - so each author will have one/more/multiple keywords in Column O and Column P.

I need these to be all listed within one row -- with one column for Keyword and a separate column Speciality/Area of Expertise. All of the multiple entries will be in the same row of that column, separated by a ";" semicolon.

Any ideas? Or, can someone point me in the right direction?

Thank you so much!

Originally Posted by ChemistB

Can you upload an example spreadsheet showing what you have and what you want? (Go Advanced>Manage Attachments)

Please see attached. Thank you.