1. I want to aggregate text information from child cells and use a line break as delimiter. How can I do this?
2. In Addition it would be nice to have "Primary Column" as prefix before the respective contents.
Example
Values for Primary Columns for two rows: Child 1, Child2
Value for relevant text cell of child 1:
- lorem 1
- lorem 2
Value for relevant text cell of child 2:
- lorem 3
- lorem 4
Output of formula (without "Child 1:" and "Child 2:" if 2 as described above is not possible):
Child 1:
- lorem 1
- lorem 2
Child 2:
- lorem 3
- lorem 4
