convert multiples to discrete items/rows?

[atr]

I have a set of data like this:
<table>
<tr><td>Qty</td><td>Price</td></tr>
<tr><td>2</td><td>5</td></tr>
<tr><td>3</td><td>4</td></tr>
<tr><td>1</td><td>6</td></tr>
</table>

Is it possible (without VBA) to convert it to this format?
<table>
<tr><td>Price</td></tr>
<tr><td>5</td></tr>
<tr><td>5</td></tr>
<tr><td>4</td></tr>
<tr><td>4</td></tr>
<tr><td>4</td></tr>
<tr><td>6</td></tr>
</table>


Thank you!

 

[atr]

Alternatively, is it possible to convert the first table into an array with discrete items?