Associate the name of columns with a value

[#1]

Hi !

I have an excel file with this 2 sheets. I want to associate the skills with their sector. How can I do that ?

User	Skill 1	Skill 2	Skill 3	Skill 4	Skill 5	Skill 6
user 1	0	2	4	2	3	0
user 2	0	1	5	2	4	1
user 3	1	3	2	1	0	2

Sector	Skill
Sector 1	skill 1
Sector 1	skill 2
Sector 1	skill 3
Sector 2	skill 4
Sector 2	skill 5
Sector 2	skill 6

Thank you 😃

Annie

[rwunderlich]

Look at crosstable in the ref guide or help. You need to add the numeric parm that indicates you have two columns.

Rob