Forum Discussion
Data Arrangement issue
I have data from several different data tables that have a little bit of data from each that I am using - one of the issues that I have though is that students, who have 8 different classes, I want t...
Hi there
if you can please send an example of your data and the expected output to assist us with your question?
if you can please send an example of your data and the expected output to assist us with your question?
Data that I have looks like this
Student name | school name | grade | Course | Attendance | lates |
Sally | Maple | 10 | Eng | 1 | 10 |
Sally | Maple | 10 | Science | 2 | 1 |
Sally | Maple | 10 | Math | 3 | 5 |
Sally | Maple | 10 | Pe | 4 | 4 |
I would like to see it like this
Student name | school name | grade | Course | course | course | course | Attendance totals | Lates total |
Sally | Maple | 10 | Eng | science | math | pe | 10 | 20 |