Hi All,
So I have a data set similar to this:
ColA ColB ColC ColD
[TABLE="class: grid, width: 256"]
<colgroup><col style="width:48pt" span="4" width="64"> </colgroup><tbody>[TR]
[TD="width: 64"]AAA
[/TD]
[TD="width: 64"]QQ[/TD]
[TD="width: 64"]T[/TD]
[TD="width: 64, align: right"]64
[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]QQ[/TD]
[TD]T[/TD]
[TD="align: right"]91[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]QQ[/TD]
[TD]Y[/TD]
[TD="align: right"]55
[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]WW[/TD]
[TD]T[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]WW[/TD]
[TD]T[/TD]
[TD="align: right"]89[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]WW[/TD]
[TD]T[/TD]
[TD="align: right"]80[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]WW[/TD]
[TD]T[/TD]
[TD="align: right"]92[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]EE[/TD]
[TD]Y[/TD]
[TD="align: right"]39[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]EE[/TD]
[TD]Y[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]QQ[/TD]
[TD]Y[/TD]
[TD="align: right"]58[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]QQ[/TD]
[TD]Y[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]QQ[/TD]
[TD]T[/TD]
[TD="align: right"]44[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]WW[/TD]
[TD]Y[/TD]
[TD="align: right"]71[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]WW[/TD]
[TD]Y
[/TD]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]WW[/TD]
[TD]T[/TD]
[TD="align: right"]61[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]WW[/TD]
[TD]T[/TD]
[TD="align: right"]31[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]WW[/TD]
[TD]Y[/TD]
[TD="align: right"]61[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]WW[/TD]
[TD]Y[/TD]
[TD="align: right"]36[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]EE[/TD]
[TD]T[/TD]
[TD="align: right"]89[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]EE[/TD]
[TD]T[/TD]
[TD="align: right"]72[/TD]
[/TR]
</tbody>[/TABLE]
and i want to make it more visual and easier to read, i want it to look like this:
[TABLE="class: grid, width: 256"]
<colgroup><col style="width:48pt" span="4" width="64"> </colgroup><tbody>[TR]
[TD="width: 64"]AAA
[/TD]
[TD="width: 64"]QQ[/TD]
[TD="width: 64"]T[/TD]
[TD="width: 64, align: right"]64[/TD]
[/TR]
[TR]
[TD="align: right"]91[/TD]
[/TR]
[TR]
[TD]Y[/TD]
[TD="align: right"]55[/TD]
[/TR]
[TR]
[TD]WW[/TD]
[TD]T[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]89[/TD]
[/TR]
[TR]
[TD="align: right"]80
[/TD]
[/TR]
[TR]
[TD="align: right"]92[/TD]
[/TR]
[TR]
[TD]EE[/TD]
[TD]Y[/TD]
[TD="align: right"]39[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]BBB
[/TD]
[TD]QQ[/TD]
[TD="align: right"]58[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]T[/TD]
[TD="align: right"]44[/TD]
[/TR]
[TR]
[TD]WW
[/TD]
[TD]Y[/TD]
[TD="align: right"]71[/TD]
[/TR]
[TR]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD]T[/TD]
[TD="align: right"]61[/TD]
[/TR]
[TR]
[TD="align: right"]31
[/TD]
[/TR]
[TR]
[TD]Y[/TD]
[TD="align: right"]61[/TD]
[/TR]
[TR]
[TD="align: right"]36[/TD]
[/TR]
[TR]
[TD]EE[/TD]
[TD]T[/TD]
[TD="align: right"]89[/TD]
[/TR]
[TR]
[TD="align: right"]72[/TD]
[/TR]
</tbody>[/TABLE]
Does anyone have a macro that can do this type of merging??
It would save me potentially hours of merging cells line by line.
Thanks in advance!!!
So I have a data set similar to this:
ColA ColB ColC ColD
[TABLE="class: grid, width: 256"]
<colgroup><col style="width:48pt" span="4" width="64"> </colgroup><tbody>[TR]
[TD="width: 64"]AAA
[/TD]
[TD="width: 64"]QQ[/TD]
[TD="width: 64"]T[/TD]
[TD="width: 64, align: right"]64
[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]QQ[/TD]
[TD]T[/TD]
[TD="align: right"]91[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]QQ[/TD]
[TD]Y[/TD]
[TD="align: right"]55
[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]WW[/TD]
[TD]T[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]WW[/TD]
[TD]T[/TD]
[TD="align: right"]89[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]WW[/TD]
[TD]T[/TD]
[TD="align: right"]80[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]WW[/TD]
[TD]T[/TD]
[TD="align: right"]92[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]EE[/TD]
[TD]Y[/TD]
[TD="align: right"]39[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]EE[/TD]
[TD]Y[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]QQ[/TD]
[TD]Y[/TD]
[TD="align: right"]58[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]QQ[/TD]
[TD]Y[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]QQ[/TD]
[TD]T[/TD]
[TD="align: right"]44[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]WW[/TD]
[TD]Y[/TD]
[TD="align: right"]71[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]WW[/TD]
[TD]Y
[/TD]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]WW[/TD]
[TD]T[/TD]
[TD="align: right"]61[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]WW[/TD]
[TD]T[/TD]
[TD="align: right"]31[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]WW[/TD]
[TD]Y[/TD]
[TD="align: right"]61[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]WW[/TD]
[TD]Y[/TD]
[TD="align: right"]36[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]EE[/TD]
[TD]T[/TD]
[TD="align: right"]89[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]EE[/TD]
[TD]T[/TD]
[TD="align: right"]72[/TD]
[/TR]
</tbody>[/TABLE]
and i want to make it more visual and easier to read, i want it to look like this:
[TABLE="class: grid, width: 256"]
<colgroup><col style="width:48pt" span="4" width="64"> </colgroup><tbody>[TR]
[TD="width: 64"]AAA
[/TD]
[TD="width: 64"]QQ[/TD]
[TD="width: 64"]T[/TD]
[TD="width: 64, align: right"]64[/TD]
[/TR]
[TR]
[TD="align: right"]91[/TD]
[/TR]
[TR]
[TD]Y[/TD]
[TD="align: right"]55[/TD]
[/TR]
[TR]
[TD]WW[/TD]
[TD]T[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]89[/TD]
[/TR]
[TR]
[TD="align: right"]80
[/TD]
[/TR]
[TR]
[TD="align: right"]92[/TD]
[/TR]
[TR]
[TD]EE[/TD]
[TD]Y[/TD]
[TD="align: right"]39[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]BBB
[/TD]
[TD]QQ[/TD]
[TD="align: right"]58[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]T[/TD]
[TD="align: right"]44[/TD]
[/TR]
[TR]
[TD]WW
[/TD]
[TD]Y[/TD]
[TD="align: right"]71[/TD]
[/TR]
[TR]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD]T[/TD]
[TD="align: right"]61[/TD]
[/TR]
[TR]
[TD="align: right"]31
[/TD]
[/TR]
[TR]
[TD]Y[/TD]
[TD="align: right"]61[/TD]
[/TR]
[TR]
[TD="align: right"]36[/TD]
[/TR]
[TR]
[TD]EE[/TD]
[TD]T[/TD]
[TD="align: right"]89[/TD]
[/TR]
[TR]
[TD="align: right"]72[/TD]
[/TR]
</tbody>[/TABLE]
Does anyone have a macro that can do this type of merging??
It would save me potentially hours of merging cells line by line.
Thanks in advance!!!