Pivot Rows to Columns and Concatenate These New Columns with Two Existing Columns

Hi All,    I have a dataset in the following format. I'd like to Pivot the values in the "Name" Column into their own separate column (I'm aware of how do this in Power Query) and then concatenate ...