Excel Pivot Help

Hello Everyone! Is it possible with a pivot table to concatenate two columns' values based on the third one and also get a sum of data based on that third value? the screenshot is attached for furth...