How to get multiple rows of info into one row

[Closed]
Report
Posts
1
Registration date
Monday April 1, 2013
Status
Member
Last seen
April 1, 2013
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
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 reply

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
46
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.