Hi,
I'm trying to add n rows based on a column value.
For example this is the result I häve now
With this I know that Mike has 2 more people with him and I need to 'inject' those 2 persons as Guest, each one as a row, also indicating that Mike is the 'parent' and the other 2 are the 'childs'.
Instead of choing the People column I can replace it with a 'Hierarchy' column indicating the hierarchy of them and also the childs have to be the rows next to the parent.
So the final result could be this
| Name | Hierarchy |
|---|
| Mike | Parent |
| Guest | Child |
Guest | Child |
| Breken | Parent |
How can I do this?
thanks in advance