How do you split a Data table in Excel?

Splitting a data table in Excel is done through the 'Split Table' functionality. Here's how:

1. Select a Cell: In the row that you want to be the first row of the new table, select any cell.

2. Split the Table: Select Table Tools Layout > Split Table. (Reference 2). This action divides the table into two separate tables, with the selected row becoming the header row of the new table.

3. Formatting (Optional): If you desire to format or style your table, select Table Tools Design and choose the style you prefer. (Reference 3).