🚀 go-pugleaf

If this is a one-shot requirement I don't think there's going to be any particular method that will do any better/faster than a manual cut/paste effort.

What I'd probably do is to copy each column of each table into a spreadsheet, so that you end up with two separate columns for each table. Save that. Then copy each column to a new single column, sort it. Save that. Then copy the sorted column and paste into a new FM document.

[edit] oh, and then just eyeball to remove the duplicates.

If it gives you the option to create a table when you paste, you can tell it the number of columns = 3. If it doesn't give that option, then paste and highlight the content, then use the Table > Convert to Table option.

You might be able to do this same cutting and pasting into a new table within FM, too, but the sorting may not be as good as it might be with a spreadsheet, as FM's table sorting mechanism has been known to be a bit problematic. If you have formatting to preserve then it might be better done in FM.

If this was more than a one-shot effort then you could script it with FrameScript.

Let us know how you get on with it --

Sheila