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