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 further review.