将不同行的列表返回到单个字段中

I have the following table:

我有下表:

|animal | name   |
|----------------|
|dog    | Fido   |
|----------------|
|dog    | Spot   |
|----------------|
|dog    | Lassie |
|----------------|
|cat    | Sue    |
|----------------|
|cat    | Ace    |
|----------------|
|cat    | Felix  |
|----------------|
|pig    | Porky  |
|----------------|
|pig    | Arnold |
|----------------|
|animal |