Brandonfromsingapore
New Member
- Joined
- Jan 5, 2012
- Messages
- 38
Hello Forum,
I was wondering if you can help me with a vba code to extract values from a table like this to multiple rows of 3 columns only.
<tbody>
</tbody>
Desired outcome is this
<tbody>
</tbody>
Thank you!
I was wondering if you can help me with a vba code to extract values from a table like this to multiple rows of 3 columns only.
Name of Students | Apples | Lemon | Oranges | Pineapple | Strawberry | Grape | Lime | Coconut |
Peter | 4 | 2 | 1 | |||||
John | ||||||||
Derrick | 3 | 1 | ||||||
Stuart | 7 | |||||||
Paul | 7 | |||||||
Mary | ||||||||
Jim | ||||||||
Susan | 9 | 2 | ||||||
Dorothy | ||||||||
Rick | 1 | 1 | ||||||
Michael |
<tbody>
</tbody>
Desired outcome is this
Peter | Apples | 4 |
Peter | Pineapple | 2 |
Peter | Strawberry | 1 |
Derrick | Oranges | 3 |
Derrick | Lime | 1 |
Stuart | Lemon | 7 |
Paul | Lemon | 7 |
Susan | Lemon | 9 |
Susan | Coconut | 2 |
The logic continues | ||
<tbody>
</tbody>
Thank you!