Hi.
I've got a list of colleagues and their respective skills (see attached sample spreadsheet, sheet "Current"). The issue is that each employee is listed more than once if it has more than one skill. Instead, I want to transpose the skills column, place it on the top row, and "X"-mark each skill for each employee (see attached sample, sheet "Goal"). I've done this before, but i don't remember. I believe i used a long if/lookup/match-kind of solution.
current
| name | skill | math | physics | science | cooking |
| john | math | ||||
| john | physics | ||||
| john | science | ||||
| eric | science | ||||
| eric | cooking | ||||
| will | physics | ||||
| tom | math | ||||
| tom | cooking |
goal
| name | math | physics | science | cooking |
| john | x | x | x | |
| eric | x | x | ||
| will | x | |||
| tom | x | x |
Anyone who knows how to do it?
I'm thankful for any help i can get.
thanks.
sam