I have this huge list of teachers who teach various subjects that I need to collate in a cleaner format. It is currently setup like this: (a teacher will teach up to 8 different courses so currently it will have 8 rows, one for each block.
sample1.JPG
I need it so that the teacher name get consolidated to ONE single row and then all of the other data gets aligned into that one row. The headings "Day1(1)", "Day2(2)", etc. will always be the top row.
sample2.JPG
Thanks
Bookmarks