Forum Discussion
Solved
Invert table by content: from people assigned to a task to tasks assigned to a person
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!
Hi 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
3 Replies
Hi 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 actually, I'm very embarrassed I haven't thought about it myself, because it completely answers my needs (((
Thank you!
