Google sheet addon which Split data on same sheet and another sheet according to the user choice.

Select the data range on active sheet.

Split by values in a column select radio button.

Select output spreadsheet new spreadsheet or current spreadsheet.

Select output column using checkbox and format option.

How to use Data Splitter Addon

1

Select table range which user want to split.

2

Select column by which user want to categorize the selected data.

3

Choose location of separated data.

4

Select columns to include in the output data.

5

Select color format of the data.

screenshots