Hi,
Would love a macro to convert multiple rows to a single row with some of these rows in the result needing to be concatenated... Found a very similar solved thread, but couldn't modify it to produce my desired result. (the link to this thread is: http://www.excelforum.com/excel-new-...02#post2833302).
I have attached the xlsx with test data. Sheet 1 has the original data, sheet 2 has the result that I want to achieve with a macro...(I have included instructions on how I achieve the result, but it requires way too many manual steps that I'm hoping you can provide a solution to)
StudentTimetable.xlsxStudentTimetable.xlsx
Thanks in advance.
Regards
Michael
Bookmarks