How it works
This function automates the process of taking a structured table in Excel, where rows represent individual records and columns represent distinct categories or data groups, and splits the data into separate sheets—one for each column (excluding fixed columns like identifiers or descriptions).
How to use it:
Step 1
In the ‘More’ drop down of the Analysing and Sampling group, click on ‘Split Table’.
A new pop-up window will appear.
Step 2
Select the columns/headings that represent the groups to be split.
Then click Ok.
Step 3
On execution, the table will be split into multiple sheets, each named in accordance with the column/heading that it is related to.
