Tupelo1984
New Member
- Joined
- Jan 26, 2021
- Messages
- 22
- Office Version
- 365
- Platform
- Windows
Dear forum,
I am searching for a way to re-structure data from a skills matrix in an analyzable data model. I have the original result and know the desired outcome, but struggling to apply this to a large matrix.
Example of the data I need to convert here below in it's actual format:
The desired format needed to be able to analyze this easier and add additional grouped categories to competencies:
The original data has 286 skills and 96 employees so a manual conversion is almost un-doable.
Thanks a lot!
Tupelo1984
I am searching for a way to re-structure data from a skills matrix in an analyzable data model. I have the original result and know the desired outcome, but struggling to apply this to a large matrix.
Example of the data I need to convert here below in it's actual format:
Team | Employee | Background | Country | Hardware A | Hardware B | Hardware C | Hardware D | Hardware E | Hardware F | Software A | Software B |
X | employee 1 | Art | Germany | EXPERT | EXPERT | EXPERT | EXPERT | EXPERT | EXPERT | EXPERT | EXPERT |
Y | employee 2 | Science | France | ADVANCED | ADVANCED | EXPERT | EXPERT | EXPERT | EXPERT | ADVANCED | ADVANCED |
Z | employee 3 | Engineer | Belgium | ADVANCED | ADVANCED | EXPERT | EXPERT | EXPERT | EXPERT | ADVANCED | ADVANCED |
The desired format needed to be able to analyze this easier and add additional grouped categories to competencies:
Team | Employee | Background | Country | Skill | Level |
X | employee 1 | Art | Germany | Hardware A | EXPERT |
X | employee 1 | Art | Germany | Hardware B | EXPERT |
X | employee 1 | Art | Germany | Hardware C | EXPERT |
X | employee 1 | Art | Germany | Hardware D | EXPERT |
X | employee 1 | Art | Germany | Hardware E | EXPERT |
X | employee 1 | Art | Germany | Hardware F | EXPERT |
X | employee 1 | Art | Germany | Software A | EXPERT |
X | employee 1 | Art | Germany | Software B | EXPERT |
Y | employee 2 | Science | France | Hardware A | ADVANCED |
Y | employee 2 | Science | France | Hardware B | ADVANCED |
Y | employee 2 | Science | France | Hardware C | EXPERT |
Y | employee 2 | Science | France | Hardware D | EXPERT |
Y | employee 2 | Science | France | Hardware E | EXPERT |
Y | employee 2 | Science | France | Hardware F | EXPERT |
Y | employee 2 | Science | France | Software A | ADVANCED |
Y | employee 2 | Science | France | Software B | ADVANCED |
Z | employee 3 | Engineer | Belgium | Hardware A | ADVANCED |
Z | employee 3 | Engineer | Belgium | Hardware B | ADVANCED |
Z | employee 3 | Engineer | Belgium | Hardware C | EXPERT |
Z | employee 3 | Engineer | Belgium | Hardware D | EXPERT |
Z | employee 3 | Engineer | Belgium | Hardware E | EXPERT |
Z | employee 3 | Engineer | Belgium | Hardware F | EXPERT |
Z | employee 3 | Engineer | Belgium | Software A | ADVANCED |
Z | employee 3 | Engineer | Belgium | Software B | ADVANCED |
The original data has 286 skills and 96 employees so a manual conversion is almost un-doable.
Thanks a lot!
Tupelo1984