Hi All,
Hope you can help me here, is getting a bit messy.
Have an Excel sheet that is generated by a different dept. We need it in a slightly different format and would like to break the data out into multiple rows from the original.
---Sample of data---
<table border="1">
<tr>
<td>Item Code</td>
<td>Description</td>
<td>Qty Small</td>
<td>Qty Medium</td>
<td>Qty Large</td>
</tr>
<tr>
<td>abcdefg</td>
<td>Tshirt</td>
<td>25</td>
<td>10</td>
<td>15</td>
</tr>
</table>
---End of Sample---
What I would like to end up with is the same, but in this format...
---Final Result---
<table border="1">
<tr>
<td>Item Code</td>
<td>Description</td>
<td>Size</td>
<td>Quantity</td>
</tr>
<tr>
<td>abcdefg</td>
<td>Tshirt</td>
<td>S</td>
<td>25</td>
</tr>
<tr>
<td>abcdefg</td>
<td>Tshirt</td>
<td>M</td>
<td>10</td>
</tr>
<tr>
<td>abcdefg</td>
<td>Tshirt</td>
<td>L</td>
<td>15</td>
</tr>
</table>
---End of Final Result---
Have had a bash with Excel, however am not an Excel guru and as such am out of my depth here
Any help in a quick script/macro that will do this for me would be gratefully appreciated,
TIA
Dan
Hope you can help me here, is getting a bit messy.
Have an Excel sheet that is generated by a different dept. We need it in a slightly different format and would like to break the data out into multiple rows from the original.
---Sample of data---
<table border="1">
<tr>
<td>Item Code</td>
<td>Description</td>
<td>Qty Small</td>
<td>Qty Medium</td>
<td>Qty Large</td>
</tr>
<tr>
<td>abcdefg</td>
<td>Tshirt</td>
<td>25</td>
<td>10</td>
<td>15</td>
</tr>
</table>
---End of Sample---
What I would like to end up with is the same, but in this format...
---Final Result---
<table border="1">
<tr>
<td>Item Code</td>
<td>Description</td>
<td>Size</td>
<td>Quantity</td>
</tr>
<tr>
<td>abcdefg</td>
<td>Tshirt</td>
<td>S</td>
<td>25</td>
</tr>
<tr>
<td>abcdefg</td>
<td>Tshirt</td>
<td>M</td>
<td>10</td>
</tr>
<tr>
<td>abcdefg</td>
<td>Tshirt</td>
<td>L</td>
<td>15</td>
</tr>
</table>
---End of Final Result---
Have had a bash with Excel, however am not an Excel guru and as such am out of my depth here
Any help in a quick script/macro that will do this for me would be gratefully appreciated,
TIA
Dan