jenabeyta1
New Member
I need to combine data for into one row from multiple that contain duplicate data as well. My example data is as follows:
ID Last Name First Name Grade Course Teacher
111 Smith Bob D Biology Mr. Walters
111 Smith Bob F Algebra Ms. Sunny
129 Garcia Jose F Civics Mr. Ford
129 Garcia Jose D English I Mr. Torres
259 Kipper Jane F Civics Ms. Justice
583 Lopez Reyna D Geometry Ms. Fuentes
583 Lopez Reyna D Choir Ms. Carson
I need it to look like...
ID Last Name First Name Grade Course Teacher Grade Course Teacher
111 Smith Bob D Biology Mr. Walters F Algebra Ms. Sunny
129 Garcia Jose F Civics Mr. Ford D English I Mr. Torres
259 Kipper Jane F Civics Ms. Justice
583 Lopez Reyna D Geometry Ms. Fuentes D Choir Ms. Carson
Can anyone help? If there is a video as well that would be great!
ID Last Name First Name Grade Course Teacher
111 Smith Bob D Biology Mr. Walters
111 Smith Bob F Algebra Ms. Sunny
129 Garcia Jose F Civics Mr. Ford
129 Garcia Jose D English I Mr. Torres
259 Kipper Jane F Civics Ms. Justice
583 Lopez Reyna D Geometry Ms. Fuentes
583 Lopez Reyna D Choir Ms. Carson
I need it to look like...
ID Last Name First Name Grade Course Teacher Grade Course Teacher
111 Smith Bob D Biology Mr. Walters F Algebra Ms. Sunny
129 Garcia Jose F Civics Mr. Ford D English I Mr. Torres
259 Kipper Jane F Civics Ms. Justice
583 Lopez Reyna D Geometry Ms. Fuentes D Choir Ms. Carson
Can anyone help? If there is a video as well that would be great!