Combine columns in pie chart or table expression

[ChanceyJoel]

How do I combine values within the same column? I am creating a sheet on a public app that does not belong to me. I do not think I can access script editor. I think I can only write dimension and measure expressions to modify a table and pie chart.

Animal	Trait
Tiger	Orange
Bird	Orange
Bird	Feathers
Tiger	Fur

I would like to get the above table to look like the table below.

Animal	Trait
Tiger	Orange, Fur
Bird	Orange, Feathers

I also want to create the following pie chart:     Orange: 50%, Fur 25%, Feathers 25%

Thank you for the help.

[vinieme12]

As below

Dimension:

Animal

Measure:

=Concat(Distinct Trait,',')

[Rams-]

Hi,

You can use:

Dimension: Animal

Measure: Concat(Distinct Trait,',')

and for the pie diagram

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!

[ChanceyJoel]

Do you know how to create the second table?