Help with Transpose tool

[arundaka02]

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

[Emil_Kos · Accepted solution]

Hi @arundaka02,

Please let me know if this is something helpful.

[arundaka02]

Thank you, @Emil_Kos !

I wasn't configuring the Transpose tool correctly and your solution has highlighted this.