Employee Task List

[Koneka]

Hey folks a lot smarter than I am, I would appreciate some help. I have a large table of employee trained tasks: about 100 employees as rows and 50ish tasks as colums that each employee can be trained in. I would like to set up two different lists: one by task (so everyone trained in task A) and a 2nd sheet/list by employee listing all the tasks they are trained in. I have tried pivot tables and cannot quite get the lists to work.

Please help

 

[alansidman]

You will have to unpivot your data to two columns. Names and Tasks

You can do this with Power Query/Get and Transform. You can then run reports that will give you what you are looking for. If you wish to upload a file to third party site, I am sure that someone here can provide you with a solution.