Hello there,
I'm wondering how can I combine these two columns, so that the result is the Course name along with the Grade. The problem is that the amount of grades varies per row, so I'm not sure how to accomplish this.
course grades Inglés 901,902,903,904,1101,1102,1103 Habilidades Comunicativas 805 Inglés 601,602,603,604,605,705,706 Habilidades Comunicativas 701 Sociales 601,602,603,604,605,701,702 Democracia 603 Química 904,1001,1002,1003,1004,1101,1102,1103 Matemáticas 1001,1002,1003,1004,804 Geometría 705,706,804 Estadística 1001,1002,1003,1004 Física 1001,1002,1003,1004,1101,1102,1103 Habilidades Comunicativas 804 Lengua Castellana 801,802,803,804,805 Habilidades Comunicativas 801,802
The expected result is:
Ingles901,Ingles902,Ingles903,Ingles904,Ingles1101,Ingles1102,Ingles1103
Sociales601,Sociales602,Sociales603,Sociales604,Sociales605,Sociales701,Sociales702
Democracia603
And so on...
Any advise?
Thank you.
Bookmarks