image

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

image
Back to Top