Macro that can merge cells

[BPTeam]

Hi All,

So I have a data set similar to this:
ColA ColB ColC ColD

AAA	QQ	T	64
AAA	QQ	T	91
AAA	QQ	Y	55
AAA	WW	T	8
AAA	WW	T	89
AAA	WW	T	80
AAA	WW	T	92
AAA	EE	Y	39
AAA	EE	Y	11
BBB	QQ	Y	58
BBB	QQ	Y	6
BBB	QQ	T	44
BBB	WW	Y	71
BBB	WW	Y	75
BBB	WW	T	61
BBB	WW	T	31
BBB	WW	Y	61
BBB	WW	Y	36
BBB	EE	T	89
BBB	EE	T	72

<colgroup><col style="width:48pt" span="4" width="64"> </colgroup><tbody>
</tbody>

and i want to make it more visual and easier to read, i want it to look like this:

AAA	QQ	T	64
91
Y	55
WW	T	8
89
80
92
EE	Y	39
11
BBB	QQ	58
6
T	44
WW	Y	71
75
T	61
31
Y	61
36
EE	T	89
72

<colgroup><col style="width:48pt" span="4" width="64"> </colgroup><tbody>
</tbody>

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!!!

 

[BPTeam]

<tbody>

	AAA	QQ	T	64
	91
	Y	55
	WW	T	8
	89
	80
	92
	EE	Y	39
	11
	BBB	QQ	58
	6
	T	44
	WW	Y	71
	75
	T	61
	31
	Y	61
	36
	EE	T	89
	72

<colgroup><col style="width:48pt" span="6" width="64"> </colgroup><tbody>
</tbody>

</tbody>