I have a table that has the following Format
<tbody>
</tbody>
I am trying to see if there is a simple way to convert that to
<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?
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?