How to insert a row in a column to match data in another column

[Super_Dave]

I have a column of road names with no rows in between and another column with same data with rows between the data. How do i get them to match up with r click insert?

 

[Super_Dave]

OK, I can't guess how your sheet actually is actually structured, and given that you can't get the XL2BB to work, could you share your workbook via Google Drive, Dropbox or similar file sharing platform?

yes sir

 

[kevin9999]

When I run the following code on your sample data:

Sub Add_Blanks()
    Dim c As Range
    For Each c In Range("B1", Cells(Rows.Count, "B").End(xlUp))
        If c = "" And c.Offset(, -1) <> "" Then c.Offset(, -1).Insert xlShiftDown
    Next c
End Sub

It goes from this:

Book1
	A	B	C
1	Hill Drive	Hill Drive	HILL DR
2
3	Hill Side Drive	Hill Side Drive	HILL SIDE DR
4
5	Hillcrest Road	Hillcrest Road	HILLCREST RD
6
7
8
9	Hillside Drive (Formerly: Lamar Taylor Road)	Hillside Drive	HILLSIDE DR
10
11	Hilltop Drive	Hilltop Drive	HILLTOP DR
12	Hillwood Lane
13	Hilton Road	Hillwood Lane	HILLWOOD LN
14	Hinds Road
15	Hinton Road	Hilton Road	HILTON RD
16	Hodge Road
17	Hodges McCullum Road	Hinds Road	HINES RD
Sheet1

to this:

Book1
	A	B	C
1	Hill Drive	Hill Drive	HILL DR
2
3	Hill Side Drive	Hill Side Drive	HILL SIDE DR
4
5	Hillcrest Road	Hillcrest Road	HILLCREST RD
6
7
8
9	Hillside Drive (Formerly: Lamar Taylor Road)	Hillside Drive	HILLSIDE DR
10
11	Hilltop Drive	Hilltop Drive	HILLTOP DR
12
13	Hillwood Lane	Hillwood Lane	HILLWOOD LN
14
15	Hilton Road	Hilton Road	HILTON RD
16
17	Hinds Road	Hinds Road	HINES RD
18	Hinton Road
19	Hodge Road
20	Hodges McCullum Road
Sheet1