VBA Line up 3 Columns

[anthonyexcel]

I have 3 sets of data that I need to line up. The columns are all sorted in alphabetical order . Please see below:
<style type="text/css">
table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #ccc;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style>

Business Group A	Sales		Business Group B	Sales		Business Group C	Sales
A	23		B	86		D	67
D	5		C	65		L	8
G	4		D	453		M	4
H	65		I	34		W	2
K	76		L	23		X	7
L	87		M	23		Z	1

<tbody>
</tbody>

I need this:
<style type="text/css">
table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #ccc;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style>

Business Group A	Sales		Business Group B	Sales		Business Group C	Sales
A	23
			B	86
			C	65
D	5		D	453		D	67
G	4
H	65
			I	34
K	76
L	87		L	23		L	8
			M	23		M	4
						W	2
						X	7
						Z	1

<tbody>
</tbody>

Thanks in advance!

 

[anthonyexcel]

Thanks Mick! It's never to late. I always appreciate your input and knowledge. Thank you for sharing your knowledge.

 

[MickG]

Your welcome, thanks for the feedback

 

[Rick Rothstein]

Thank you all for your help. I appreciate all the help and guidance. Thanks you all again. The information is fantastic.

You are quite welcome. I found your question so intriguing that I created code for a completely generalized setup instead of the fixed setup you posted and then I posted in my mini-blog. Here is a link to that article...

<!-- title / author block --> [h=3]Align Data In Groups Of Columns[/h]

 

[anthonyexcel]

Nice Rick! Thank you so much for posting the mini-blog. I am sure that many people will take advantage of your approach. Thank you again for all of your contributions in which I always find very intriguing. Thank you again! Have a wonderful day!

 

[hiker95]

MickG,

Thank you very much - another for my archive.

 

[hiker95]

Rick Rothstein,

Thank you very much - two more for my archive.

 

[MickG]

Hiker, you're very welcome.