Forum Discussion

rainbringer's avatar
rainbringer
Copper Contributor
Jun 18, 2020
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 crea...
excel
  • Bennadeau's avatar
    Bennadeau
    Jun 19, 2020

    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's avatar
Bennadeau
Iron Contributor
Jun 19, 2020

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
  • rainbringer's avatar
    rainbringer
    Copper Contributor
    Jun 19, 2020

    Bennadeau ,

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

    Thank you!

    • Bennadeau's avatar
      Bennadeau
      Iron Contributor
      Jun 20, 2020

      rainbringer 

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

      You're welcome!

      Ben

       

Resources