Combining Duplicate Rows

[edmund_belleza]

I have a dataset with some duplicate rows. During any particular time frame, an employee (EmployeeID) can be assigned to one or more teams focusing on one more Topics (Topic_ID).

Due to an overlap Start/End dates (START DT and END DT) duplicate rows are created for employees. 

For those employees with duplicate rows, I'd like to combine their duplicate rows into one row, creating additional columns (TEAM_ID2, TOPIC_ID2, START DT2, END DT2) for the duplicates.

I've seen variations of this topic posted on the Community, even one that does the reverse. But I'm having trouble figuring out the best workflow.

Any help would be greatly appreciated. Thank you!

Before:

After:

Hi,

[Qiu · Accepted solution]

@edmund_belleza 
Hope this is what you need here.

[edmund_belleza · Accepted solution]

Thanks again for the proposed solution. I was able to adapt this to our data set and it seems to be working well.

Thanks again!