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 to show on the same row with the student name and demographics etc vs the student showing up as 8 different rows with the data for each class showing up as its own row :(
any suggestions thanks
3 Replies
- GilbertQSuper UserHi there
if you can please send an example of your data and the expected output to assist us with your question?- AnonymousNot applicable
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
- AnonymousNot applicable
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