Separate data in columns to match a specific number of rows

[zgsharon]

Had no Idea how to title this, so to start with if anyone has a better title please help me out. New to Mr.Excel and hoping someone knows what I'm attempting to do. I am trying separate a specific number of rows in multiple columns to match another set of data with a greater number of rows. So I want to take the data in columns A, B, and C (see example below) and make the same data match the number of rows in D, E, and F with blank cells filling in the extra rows. So basically I need to spread a specific column of data into a new column with a set range of rows.

A	B	C		D	E	F
6	6	6		5	5	4
45	45	45		64	45	23
4	4	4		43	4	23
5	5	5		234	23	4
				64	46	5
				234	64	5
				24	2	43
				3	34	34
				5	4	23
				6	56	1
				4	23	32

<tbody>
</tbody>

Hoping that it would look something like this.

A	B	C		D	E	F
6	6	6		5	5	4
				64	45	23
				43	4	23
				234	23	4
45	45	45		64	46	5
				234	64	5
				24	2	43
				3	34	34
4	4	4		5	4	23
				6	56	1
				4	23	32
5	5	5		23	4	12

<tbody>
</tbody>

I know the number of rows in the first three columns won't always be a multiple of the other three columns, I just need it to keep the first and last values of each set of data lined up with each other in the same row. The values in between can be spaced randomly, as they are above.

I have found this code, and it helps a little, but I don't know how to make the code do multiple columns at once.
Sub MG28Sep05()
Dim Last As Integer, n
' Change "A" Below To another column Letter
Last = Range("A" & Rows.Count).End(xlUp).row

For n = Last To 2 Step -1
' Change "7" Below To No of Blank Rows Required
Cells(n, 1).Resize(7).Insert shift:=xlDown
Next n
End Sub


Thanks for any help in advance. I apologize for the terrible explanation, just hoping someone has wanted to attempt to do the same thing. I am using Office 365 on windows. Let me know if you need any more information