I am working with a database that deals with student scheduling in schools. I am getting repeated lines for each class a student is enrolled in and need to consolidate them into 1 line per student. I prefer to do this by copying to a second sheet in the workbook so I have the master to go back to if needed.
The way the spreadsheet is set up, if the values in columns A & B (last name & first name) are the same from row to row, then I need the information in columns H-R to be repeated starting in column S for as many courses as the student is enrolled in. This number will vary for every student.