Creating multiple rows from single row

[Sinjinmanta]

I'm not sure how to even phrase this question. I want to take a table of data and create rows for each entry.

What I have:
[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Name[/TD]
[TD="class: xl65, width: 64"]Algebra[/TD]
[TD="class: xl65, width: 64"]Biology[/TD]
[TD="class: xl65, width: 64"]Literature[/TD]
[/TR]
[TR]
[TD]Student 1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Student 2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Student 3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]


What I want to go to:
[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Student 1[/TD]
[TD="width: 64, align: right"]1[/TD]
[TD="class: xl65, width: 64"]Algebra[/TD]
[/TR]
[TR]
[TD]Student 1[/TD]
[TD="align: right"]4[/TD]
[TD="class: xl65"]Biology[/TD]
[/TR]
[TR]
[TD]Student 1[/TD]
[TD="align: right"]3[/TD]
[TD="class: xl65"]Literature[/TD]
[/TR]
[TR]
[TD]Student 2[/TD]
[TD="align: right"]3[/TD]
[TD="class: xl65"]Algebra[/TD]
[/TR]
[TR]
[TD]Student 2[/TD]
[TD="align: right"]2[/TD]
[TD="class: xl65"]Biology[/TD]
[/TR]
[TR]
[TD]Student 2[/TD]
[TD="align: right"]3[/TD]
[TD="class: xl65"]Literature[/TD]
[/TR]
[TR]
[TD]Student 3[/TD]
[TD="align: right"]2[/TD]
[TD="class: xl65"]Algebra[/TD]
[/TR]
[TR]
[TD]Student 3[/TD]
[TD="align: right"]2[/TD]
[TD="class: xl65"]Biology[/TD]
[/TR]
[TR]
[TD]Student 3[/TD]
[TD="align: right"]3[/TD]
[TD="class: xl65"]Literature[/TD]
[/TR]
</tbody>[/TABLE]

 

[lrobbo314]

This is done easily with PowerQuery by selecting the first column, then under the 'Transform' tab, select 'Unpivot Other Columns'.

 

[Sinjinmanta]

Thank you! That worked perfectly!