In this example, the ampersand is concatenating the value in cell A2, a space, and the value in cell B2 to return a full name ... and press Enter to duplicate it in the remaining cells in the column: ...

I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into ...