Quick Append in Power Query???

[TDC21]

I have a table that has the following Format

Plate Group	Count	Market	Cost/LB	Markup	Markup %
<= 1.5 and <= 120	319	.46	.39	.07	18%

<tbody>
</tbody>

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

Plate Group	Type	Value
<= 1.5 and <= 120	Count	319
<= 1.5 and <= 120	Market	.46
<= 1.5 and <= 120	Cost/LB	.39
<= 1.5 and <= 120	Markup	.07
<= 1.5 and <= 120	Markup %	18%

<tbody>
</tbody>

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”