So, select any cell in your formatted Excel table, and in the Insert Tab on the ribbon, click the top half of the split "PivotChart" button.

W hen you're working with data in Excel, certain tasks can feel unnecessarily tedious. Maybe you need to split a column of full names into separate first and last name columns, or combine text from ...