convert multiples to discrete items/rows?

atr

New Member
Joined
Sep 6, 2005
Messages
10
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!
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

atr

New Member
Joined
Sep 6, 2005
Messages
10
Alternatively, is it possible to convert the first table into an array with discrete items?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,081
Messages
5,570,086
Members
412,310
Latest member
mark884
Top