Hello everyone. I'm hoping someone can help. I have a spreadsheet with workers with what they know how to do. Some people only know their own job, while others have been cross-trained. I originally had it with one row for each person and each function they know in a different column. However, it made it difficult to show in a pivot table. So then I figured I could do it below. However, it doesn't feel like it's the best way to do it since I have to enter the same person's information in each time (same name, same team, other information), only to add an extra field that he's been trained in. Is this the only way to do it or am I missing something? Thank you in advance.
Name Team Trained in
Derek D Installation Installation
Derek D Installation Billing
Bob B Installation Installation
Kate K Finance Finance
Kate K Finance Billing
Mary M Claims Claims
Mary M Claims Installation
Mary M Claims Billing
Mary M Claims Finance
Bookmarks