Forum Discussion
Najam_Ahmed
Aug 24, 2023Copper Contributor
data analysis
I have collected a vast amount of data from trainees who have undergone training in various fields. The data covers different aspects of training, rated on a scale of 1 to 5. I am looking for a formu...
Detlef_Lewin
Aug 24, 2023Silver Contributor
I can't find trainee ids or trainee namen in the photo.
- Najam_AhmedAug 24, 2023Copper Contributor
no need for trainee name or photo just the area name needed and against that how many 5, 4, 3, 2 and 1 again each aspect.
- Detlef_LewinAug 24, 2023Silver Contributor
I understand. Each row is a different trainee.
Unpivot the columns C:M. The resulting table can be analysed in any way you want.
- Najam_AhmedAug 24, 2023Copper Contributoryes, each row is a different trainee but for some reason name are no shown. Bu how can I unpivot the the columns you mentioned.