SOLVED

Invert table by content: from people assigned to a task to tasks assigned to a person

Copper Contributor

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!

3 Replies
best response confirmed by rainbringer (Copper Contributor)
Solution

Hi @rainbringer ,

I understand this is not quite what you are looking for but how about you change the layout of your table?

 JohnAlexSam
Buy grocery    x    x 
Cook food    x     x
eat food     x    x

@Bennadeau ,

actually, I'm very embarrassed I haven't thought about it myself, because it completely answers my needs (((

Thank you!

@rainbringer 

Lol! Don't be embarrassed, that's why we're here.

You're welcome!

Ben

 

1 best response

Accepted Solutions
best response confirmed by rainbringer (Copper Contributor)
Solution

Hi @rainbringer ,

I understand this is not quite what you are looking for but how about you change the layout of your table?

 JohnAlexSam
Buy grocery    x    x 
Cook food    x     x
eat food     x    x

View solution in original post