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
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