Google sheet addon which Split data on same sheet and another sheet according to the user choice.
YouTube video how to use it
How to use Color Duplicates Addon
Select table range which user want to split.
Select column by which user want to categorize the selected data.
Choose location of separated data.
Select columns to include in the output data.
Select color format of the data.