VBA code to merge rows

[dfolzenlogen]

Hello,

I am trying to merge cells in rows based on the value of the cell in Column A of my spreadsheet (containing Document Type) through the continuous rows containing no Document Type in Column A [see below BEFORE and AFTER examples below]. This needs to loop through the entire spreadsheet.

BEFORE:

Book Type	Volume	Page	Subdivision	Lot	Block	Section	Survey	Abs No.	Grantor	Grantee
Deed Record	1586	7	WOODLAND TRAILS	4	3				REID ROY H	ROY REID BUILDING COMPANY
									REID WILMA L
Deed Record	1589	581	WOODLAND TRAILS	20	1				REID ROY H	ROY REID BUILDING COMPANY
			WOODLAND TRAILS	13	2				REID WILMA L
			WOODLAND TRAILS	45	1
Deed Record	1589	583							REID ROY	PUBLIC
									REID WILMA L
Deed Record	1589	771	J M ATER ADDITION 1	1	6				SHERMAN BILL	REID BILL
			J M ATER ADDITION 1	3	6
Deed Record	1595	772	WOODLAND TRAILS	15	3				REID ROY H	WOOFTER JOSEPH E
									REID WILMA L	WOOFTER PATRICIA M
Deed Record	1595	863	WOODLAND TRAILS	15	3				CENTRAL TEXAS SAVINGS AND LOAN ASSOCIATION	REID ROY H
										REID WILMA L

<tbody>
</tbody>

AFTER:

Book Type	Volume	Page	Subdivision	Lot	Block	Section	Survey	Abs No.	Grantor	Grantee	Document Type
Deed Record	1586	7	WOODLAND TRAILS	4	3				REID ROY H REID WILMA L	ROY REID BUILDING COMPANY	WD
Deed Record	1589	581	WOODLAND TRAILS WOODLAND TRAILS WOODLAND TRAILS	20 13 45	1 2 1				REID ROY H REID WILMA L	ROY REID BUILDING COMPANY	WD
Deed Record	1589	583							REID ROY REID WILMA L	PUBLIC	RESO
Deed Record	1589	771	J M ATER ADDITION 1 J M ATER ADDITION 1	1 3	6 6				SHERMAN BILL	REID BILL	QCD
Deed Record	1595	772	WOODLAND TRAILS	15	3				REID ROY H REID WILMA L	WOOFTER JOSEPH E WOOFTER PATRICIA M	WDVL
Deed Record	1595	863	WOODLAND TRAILS	15	3				CENTRAL TEXAS SAVINGS AND LOAN ASSOCIATION	REID ROY H REID WILMA L	ROL

<tbody>
</tbody>

I am able to do this using an Add-in from John Walkenbach's PUP v7.2 but have to select the rows. I have added the code to the Quick Access menu but it's still a lot of highlighting and clicking. I'm still too new to VBA to even know where to begin. I'm hoping there's a solution to this issue.

Thanks in advance.

 

[dfolzenlogen]

My earlier post inadvertently said Document Type when it should have said Book Type. Apologies.