To turn your big data set into a PivotTable, select any cell in the range, and in the Insert tab on the ribbon, click the top ...

To split the cells, start by selecting the merged cells on the sheet. Next, navigate to the Alignment group in the ribbon of the Home tab. Click the down arrow next to the Merge and Center button and ...