How to get multiple rows of info into one row

Closed
ddunkel Posts 1 Registration date Monday April 1, 2013 Status Member Last seen April 1, 2013 - Apr 1, 2013 at 03:34 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Apr 1, 2013 at 11:35 PM
Student schedules were sent to me on several lines (one line per class) so each student has from 5-7 rows of information. I want each student to have one row with the entire schedule displaying across that one row, multiple columns. Each student has a unique ID number.

Suggestions? I really need step-by-step at this point. It is a very large spreadsheet with 11 columns and 28,331 rows!

Thank you!!

1 response

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Apr 1, 2013 at 11:35 PM
Hi ddunkel,

I would like to help you here. From your description of the problem it is difficult to find a fix. It is requested that you post some sample data in the forum. Also, it will be a good idea if you could upload the sample file to the following link:

https://authentification.site

28,331 rows and 11 columns is indeed a huge sheet, please do not upload the original sheet to the above link as it might contain personal information and also it will be a huge file to work on.

Please do write back to us.
0