Consolidating multiple rows into a column

I have a data set that is benefit enrollment data - there is a row for every plan that an employee enrolls in - which means there are variable amounts of rows for every employee.

I need to format this for our call center int a census report where the info is in columns so they can search and see the employee information and the plans enrolled is in columns.

I initially created a pivot table that uses the unique id for each employee and created a vlookup that pulls all the information, but it’s just pulling the first row.

I thought about an if formula for each plan name and then concate to put it all in one column for each employee, but the issue still stands that the amount of rows varies and if I drag it down it’s not necessarily tied to the employee but whatever is in that column.

I feel like I’m so close but so far away.

I know I could pivot columns in PBI but I don’t know that the call center can work with a pbi file. They need to be able to search/filter which is why I thought the reference table would work.

This will have to be done monthly and I’m hoping to find a solution that minimizes the time spent formatting.