Summarizing Text from Children

Regen

I have a hierarchy set up and want the parent line to automatically pick up all text in the same column as the children, ideally unique/distinct values only.

For example, my children are

"SEA

Singapore"

"SEA

Vietnam"

"Indonesia

SEA"

Thailand

Which are all items selected from a drop-down menu

I want the formula to return SEA Singapore Vietnam Indonesia Thailand. Is there any way to do this?

Paul Newcome

Try something like this...

=JOIN(DISTINCT(COLLECT(CHILDREN(), CHILDREN(), @cell <> "")), " ")