Order a rows in a sheet by copying and pasting rows to new sheet

[capson]

Hello,

In sheet1, in column A I have a unique list of names (of variable length)


I run a similarity algorithm on this column and get in column B the closest non-identical match to the name in column A for each row


Because the Fuzzy match was on a list to itself each match has a corresponding match in column A


e.g.

[TABLE="width: 345"]
<tbody>[TR]
[TD]Name[/TD]
[TD]FM_Name[/TD]
[/TR]
[TR]
[TD]Kathryn Hall Trujillo[/TD]
[TD]Kathryn Hall-Trujillo[/TD]
[/TR]
[TR]
[TD]Kathryn Hall-Trujillo[/TD]
[TD]Kathryn Hall Trujillo[/TD]
[/TR]
[TR]
[TD]Giselle Corbie-Smith[/TD]
[TD]Gisselle Corbie-Smith[/TD]
[/TR]
[TR]
[TD]Gisselle Corbie-Smith[/TD]
[TD]Giselle Corbie-Smith[/TD]
[/TR]
</tbody>[/TABLE]

If the spellings differences are very small the match and its corresponding match are in adjacent rows as above

But if the names have a greater degree of difference then they are separated by multiple rows

e.g.

[TABLE="width: 305"]
<tbody>[TR]
[TD]Name[/TD]
[TD]FM_Name[/TD]
[/TR]
[TR]
[TD]Dr. Veronica Womack[/TD]
[TD]Veronica Womack[/TD]
[/TR]
[TR]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]Veronica Womack[/TD]
[TD]Dr. Veronica Womack[/TD]
[/TR]
</tbody>[/TABLE]

I need in Sheet2 the rows such that all pairings are adjacent
e.g.

[TABLE="width: 305"]
<tbody>[TR]
[TD]Name[/TD]
[TD]FM_Name[/TD]
[/TR]
[TR]
[TD]Kathryn Hall Trujillo[/TD]
[TD]Kathryn Hall-Trujillo[/TD]
[/TR]
[TR]
[TD]Kathryn Hall-Trujillo[/TD]
[TD]Kathryn Hall Trujillo[/TD]
[/TR]
[TR]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]Giselle Corbie-Smith[/TD]
[TD]Gisselle Corbie-Smith[/TD]
[/TR]
[TR]
[TD]Gisselle Corbie-Smith[/TD]
[TD]Giselle Corbie-Smith[/TD]
[/TR]
[TR]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]Dr. Veronica Womack[/TD]
[TD]Veronica Womack[/TD]
[/TR]
[TR]
[TD]Veronica Womack[/TD]
[TD]Dr. Veronica Womack[/TD]
[/TR]
[TR]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]name_last[/TD]
[TD]Fm_name_last[/TD]
[/TR]
[TR]
[TD]Fm_name_last[/TD]
[TD]name_last[/TD]
[/TR]
</tbody>[/TABLE]

And I need the entire Row moved as there is a variable number of columns with data after column B

Thank you in advance for help on this, I have got nowhere with this myself