Join texts together when count > 1 in pivot table

[freelensia]

Hi,

I have the following table

Name Degree
John BA
Peter BA
Peter MBA

When I do a pivot table for Name & Count of Names, I get

Name Count of Name
John 1
Peter 2

Is it possible in this case to join texts under degree if more than 1 exist? So that...

Name Count of Name Degrees
John 1 BA
Peter 2 BA, MBA

I know this can be done with VBA and formulas, but I want to do it with Pivot Table natively.

Your help is greatly appreciated!

Freelensia Interpreter Reservation Platform