Bushranger
New Member
- Joined
- Mar 12, 2019
- Messages
- 5
I have two issues I'm trying to solve
1: I have this:
<tbody>
</tbody>
And need it to look like this
<tbody>
</tbody>
2. I have this
<tbody>
</tbody>and need it to look like this
<tbody>
</tbody>
Any help appreciated. I don't know much about VBA, Pivot etc but can follow instructions very well.
1: I have this:
Doug | Before | 7 |
Doug | During | 4 |
Doug | After | 9 |
Jim | Before | 3 |
Jim | During | 7 |
Jim | After | 4 |
Karen | Before | 3 |
Karen | After | 6 |
<tbody>
</tbody>
And need it to look like this
Name | Before | During | After |
Doug | 7 | 4 | 9 |
Jim | 3 | 7 | 4 |
Karen | 3 | 6 |
<tbody>
</tbody>
2. I have this
Sally | Yellow |
Sally | Blue |
Sally | Green |
Jenny | Red |
Jenny | Green |
Dory | Green |
Dory | Blue |
<tbody>
</tbody>
Sally | Yellow | Blue | Green |
Jenny | Red | Green | |
Dory | Green | Blue |
<tbody>
</tbody>
Any help appreciated. I don't know much about VBA, Pivot etc but can follow instructions very well.