Magoosball
Board Regular
- Joined
- Jun 4, 2017
- Messages
- 70
- Office Version
- 365
I am trying to add onto a current VBA script to do the following:
The name itself and the number of names will be different each time the script is ran.
Before
<tbody>
</tbody>
After: Column 2 should only have 4 merged cells going down in this example. Each 1 with Mike should be merged, each with April should be merged, Each with James merged and each with Thor merged. Wasn't sure how to add that in this table.
<tbody>
</tbody>
Thank you in advance!!
The name itself and the number of names will be different each time the script is ran.
Before
Name | Animal |
Mike | Elephant |
Mike | Dragon |
Mike | Dog |
Mike | Cat |
Mike | Mourse |
Mike | Bird |
Mike | Hawk |
April | Lion |
April | Tiger |
April | Bear |
James | Panda |
James | Snake |
Thor | Cobra |
Thor | Lion |
Thor | Dragon |
Thor | Mouse |
Thor | Bear |
Thor | Hawk |
<tbody>
</tbody>
After: Column 2 should only have 4 merged cells going down in this example. Each 1 with Mike should be merged, each with April should be merged, Each with James merged and each with Thor merged. Wasn't sure how to add that in this table.
Name | Animal |
Mike | Elephant, Dragon, Dog, Cat, Mouse, Bird, Hawk |
Mike | |
Mike | |
Mike | |
Mike | |
Mike | |
Mike | |
April | Lion, Tiger, Bear |
April | |
April | |
James | Panda, Snake |
James | |
Thor | Cobra, Lion Dragon, Mouse, Bear, Hawk |
Thor | |
Thor | |
Thor | |
Thor | |
Thor |
<tbody>
</tbody>
Thank you in advance!!