Group values in single column into separate lists

[kduong1]

Hi there, 

I am trying to create separate lists based on grouping the unique values in a single column - how can I go about doing this? See example below.

I have the following data and want to group unique animals into separate tables/lists:

Animal	Color
Dog	Black
Dog	Brown
Dog	White
Cat	Orange
Cat	White
Hamster	Brown
Hamster	Gray

The ideal result would be:

Animal	Color
Dog	Black
Dog	Brown
Dog	White

Animal	Color
Cat	Orange
Cat	White

Animal	Color
Hamster	Brown
Hamster	Gray

I do not want to simply filter by hardcoding the actual values (i.e. filtering to only dog), as my real dataset contains large variations of data.

Please advise.

Thank you!

[binuacs]

@kduong1 One way of doing this with the table tool

[Qiu]

@kduong1 
@binuacs  provided a sample using Reporting tool. We can also output several Excel files if you need.