
Data Splitter
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
Step 1: Select the data range on active sheet
Select table range which user want to split.
Step 2: Split by values in a column
Select column by which user want to categorize the selected data.
Step 3: Select Output Spreadsheet
Choose location of separated data.
Step 4: Output Columns
Select columns to include in the output data.
Step 4: Format Options
Select color format of the data.
Screenshot
