SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-1476423%22%20slang%3D%22en-US%22%3EInvert%20table%20by%20content%3A%20from%20people%20assigned%20to%20a%20task%20to%20tasks%20assigned%20to%20a%20person%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1476423%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI'm%20working%20in%20Excel%202013.%3C%2FP%3E%3CP%3EI%20have%20a%20table%20that%20contains%20tasks%20and%20people%20assigned%20to%20each%20task.%20Tasks%20are%20unique%2C%20buy%20a%20person%20can%20be%20assigned%20more%20to%20one%20task.%3C%2FP%3E%3CP%3EI%20need%20to%20find%20a%20way%20to%20create%20an%20%22inverted%20table%22%3A%20a%20list%20of%20people%20(unique%20names)%20and%20tasks%20assigned%20to%20each%20person.%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20it%20be%20achieved%3F%3C%2FP%3E%3CP%3EMany%20thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1476423%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1477694%22%20slang%3D%22en-US%22%3ERe%3A%20Invert%20table%20by%20content%3A%20from%20people%20assigned%20to%20a%20task%20to%20tasks%20assigned%20to%20a%20person%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1477694%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F704340%22%20target%3D%22_blank%22%3E%40rainbringer%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3EI%20understand%20this%20is%20not%20quite%20what%20you%20are%20looking%20for%20but%20how%20about%20you%20change%20the%20layout%20of%20your%20table%3F%3C%2FP%3E%3CTABLE%20width%3D%22285%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2279%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2271%22%3EJohn%3C%2FTD%3E%3CTD%20width%3D%2271%22%3EAlex%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ESam%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EBuy%20grocery%3C%2FTD%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20x%3C%2FTD%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20x%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECook%20food%3C%2FTD%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20x%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20x%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3Eeat%20food%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20x%3C%2FTD%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20x%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1478287%22%20slang%3D%22en-US%22%3ERe%3A%20Invert%20table%20by%20content%3A%20from%20people%20assigned%20to%20a%20task%20to%20tasks%20assigned%20to%20a%20person%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1478287%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F703724%22%20target%3D%22_blank%22%3E%40Bennadeau%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3Eactually%2C%20I'm%20very%20embarrassed%20I%20haven't%20thought%20about%20it%20myself%2C%20because%20it%20completely%20answers%20my%20needs%20(((%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1478496%22%20slang%3D%22en-US%22%3ERe%3A%20Invert%20table%20by%20content%3A%20from%20people%20assigned%20to%20a%20task%20to%20tasks%20assigned%20to%20a%20person%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1478496%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F704340%22%20target%3D%22_blank%22%3E%40rainbringer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELol!%20Don't%20be%20embarrassed%2C%20that's%20why%20we're%20here.%3C%2FP%3E%3CP%3EYou're%20welcome!%3C%2FP%3E%3CP%3EBen%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted
Best Response confirmed by rainbringer (New 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
Highlighted

@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