Jun 18 2020 11:15 PM
Hello,
I'm working in Excel 2013.
I have a table that contains tasks and people assigned to each task. Tasks are unique, buy a person can be assigned more to one task.
I need to find a way to create an "inverted table": a list of people (unique names) and tasks assigned to each person.
How can it be achieved?
Many thanks!
Jun 19 2020 11:34 AM
SolutionHi @rainbringer ,
I understand this is not quite what you are looking for but how about you change the layout of your table?
John | Alex | Sam | |
Buy grocery | x | x | |
Cook food | x | x | |
eat food | x | x |
Jun 19 2020 10:39 PM
actually, I'm very embarrassed I haven't thought about it myself, because it completely answers my needs (((
Thank you!
Jun 20 2020 04:51 AM
Jun 19 2020 11:34 AM
SolutionHi @rainbringer ,
I understand this is not quite what you are looking for but how about you change the layout of your table?
John | Alex | Sam | |
Buy grocery | x | x | |
Cook food | x | x | |
eat food | x | x |