Data Arrangement issue

[channah]

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 

[GilbertQ]

Hi there

if you can please send an example of your data and the expected output to assist us with your question?

[channah]

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

[channah]

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