Hi all,
I have a little problem, maybe you can help me. So I have a dataset for example like this:
boss sub
Jim Kate
Lisa Jim
Dave Lisa
Dave Erik
Anna Mary
Anna Ben
Erik Anna
. Dave
and I should list all of the subordinates for each boss.
The table I would like to have shoud be something like this:
boss sub1 sub2 sub3 sub4 sub5 sub6 sub7
Jim Kate
Lisa Jim Kate
Dave Lisa Jim Kate Erik Anna Mary Ben
Anna Mary Ben
Erik Anna Mary Ben
Or even better like this:
boss sub
Jim Kate
Lisa Jim
Lisa Kate
Dave Lisa
Dave Jim
Dave Kate
Dave Erik
Dave Anna
Dave Mary
Dave Ben
Anna Mary
Anna Ben
Erik Anna
Erik Mary
Erik Ben
Maybe this would be ok too:
sub boss1 boss2 boss3 boss4
Kate Jim Lisa Dave
Jim Lisa Dave
Lisa Dave
Erik Dave
Mary Anna Erik Dave
Ben Anna Erik Dave
Dave
Do you have any tips, how to do this? Naturally, I don't know in advance how many boss/subordinates the data includes.. Thanks for any help
... View more