Quick Append in Power Query???

[TDC21]

I have a table that has the following Format

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Plate Group[/TD]
[TD]Count[/TD]
[TD]Market[/TD]
[TD]Cost/LB[/TD]
[TD]Markup[/TD]
[TD]Markup %[/TD]
[/TR]
[TR]
[TD]<= 1.5 and <= 120[/TD]
[TD]319[/TD]
[TD].46[/TD]
[TD].39[/TD]
[TD].07[/TD]
[TD]18%[/TD]
[/TR]
</tbody>[/TABLE]

I am trying to see if there is a simple way to convert that to

[TABLE="width: 500"]
<tbody>[TR]
[TD]Plate Group[/TD]
[TD]Type[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]<= 1.5 and <= 120[/TD]
[TD]Count[/TD]
[TD]319[/TD]
[/TR]
[TR]
[TD]<= 1.5 and <= 120[/TD]
[TD]Market[/TD]
[TD].46[/TD]
[/TR]
[TR]
[TD]<= 1.5 and <= 120[/TD]
[TD]Cost/LB[/TD]
[TD].39[/TD]
[/TR]
[TR]
[TD]<= 1.5 and <= 120[/TD]
[TD]Markup[/TD]
[TD].07[/TD]
[/TR]
[TR]
[TD]<= 1.5 and <= 120[/TD]
[TD]Markup %[/TD]
[TD]18%[/TD]
[/TR]
</tbody>[/TABLE]

I could make make duplicate tables and edit them so that they can be appended but this worksheet already has 5 queries, I am hoping there is a way to avoid adding another 5 just to reformat data that I already have.

Any thoughts, or just do the extra queries and append?

 

[Matt Allington]

Yes. It is called unpivot. Right click on the first column, then select the context menu “unpivot other columns”