Merge tables based upon row headers

[trustmywords]

I want to Merge selected tables based upon row headers. The data looks like this

Table 1

Column A Column B
Name: John Wilson
Address1: 232 Main Rd
Address2:
City1: Dallas
Phone: 292 255-2323

Table 2

Name: Frank Robertson
Address1: Apt 24A
Address2: 535 Hollywood AVe
City1: Hollywood

The output should be like

Name: John Wilson Frank Robertson
Address1: 232 Main Rd Apt 24A
Address2: 535 Hollywood Ave
City1: Dallas Dallas
Phone: 292 255-2323

Is there any macro that i can arrange in this format when selected.

Thanks