riconess22
New Member
- Joined
- Jan 25, 2013
- Messages
- 30
I'm looking to take a table with consolidated quantities and explode it back into unconsolidated cells. Meaning I have the following table:
<tbody>
</tbody>
I want a formula or macro that then turns or creates a table next to it or below it:
<tbody>
</tbody>
Yellow | 3 |
Blue | 5 |
Red | 2 |
<tbody>
</tbody>
I want a formula or macro that then turns or creates a table next to it or below it:
Yellow | |
Yellow | |
Yellow | |
Blue | |
Blue | |
Blue | |
Blue | |
Blue | |
Red | |
Red |
<tbody>
</tbody>