Hello. I am trying to get the dupicate names on one row with multiple columns. This is what I have:

Smith, A. Education
Smith, A. Government
Smith, A. Marketing


I need it to look like this:
Column A Column B Column C Column D
Smith, A. Education Government Marketing