The ampersand symbol is a quick and easy way to combine data in Excel. To explain this method to you, I have created sample data in Excel with the names of some persons (refer to the above screenshot) ...
Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.