How to Concatenate Values of Pivot Table

How to Concatenate Values of Pivot Table

Concatenate is an excel function that allows you to join two or more strings together. When creating a Pivot table, you may want to combine data from two or more columns to form a single column. An example, you may wish to combine the names field with the address field to form a single column