Hi everyone
I want to analyse a skills matrix style data set which currently looks something like this:
| Email address (unique identifier) | Skill 1 | Skill 2 | Skill 3 | Skill 4 | Skill 5 |
| example1.example1@xyz.com | 2 | 1 | 3 | 3 | 3 |
| example2.example2@xyz.com | 0 | 3 | 3 | 1 | 0 |
| example3.example3@xyz.com | 3 | 3 | 2 | 2 | 1 |
| example4.example4@xyz.com | 3 | 1 | 2 | 0 | 3 |
| example5.example5@xyz.com | 1 | 1 | 1 | 3 | 2 |
The data within the table represents the respondent's proficiency level of that particular skill.
I want to transpose this data for data visualisation purposes so it looks like this:
| Email address | Skill (new column name) | Skill Score (new column name) |
| example1.example1@xyz.com | Skill 1 | 2 |
| example1.example1@xyz.com | Skill 2 | 1 |
| example1.example1@xyz.com | Skill 3 | 3 |
| example1.example1@xyz.com | Skill 4 | 3 |
| example1.example1@xyz.com | Skill 5 | 3 |
example2.example2@xyz.com | Skill 1 | 0 |
| example2.example2@xyz.com | Skill 2 | 3 |
| example2.example2@xyz.com | Skill 3 | 3 |
| example2.example2@xyz.com | Skill 4 | 1 |
| example2.example2@xyz.com | Skill 5 | 0 |
I've been playing around with the transpose tool but I can't get my data to resemble the above?
Can anyone help?
Many thanks
KA
