Combine two Columns

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.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hello,

Find the file attached.
Thank you for your time.

How about

Please Login or Register  to view this content.

Used like

Formula:

Please Login or Register  to view this content.

Here are the steps that you can take to produce the output from post #5 given your workbook from post #3:

1) Highlight your data > Data > From Table > OK
2) Select Column2 > Change Data Type to Text > Replace current
3) Select Column2 > Transform > Split Column > By Delimiter > Comma > Each occurrence > OK
4) Select Column1 > Unpivot other columns
5) Remove attribute column by selecting it then going to Home > Remove Columns
6) Sort by Column1 then by the Value column by clicking on the drop down to the right of the headers then selecting Ascending
7) Add Column > Column From Examples > Type Artística601 into the first row > OK
8) Remove value column
9) Select Column1 > Group By > Group by: Column 1 > New column name: Result > Operation: All Rows > OK
10) Add Column > Custom Column > formula: =Table.Column([Result],"Merged") > OK
11) Click on the button to the right of the Custom column header and select Extract Values > Comma > OK
12) Remove Result column
13) Close & Load

Once you have this set up, all that you have to do going forward is put any new data at the bottom of the table and refresh the green Power Query table.