Table Techniques needed

[RioRondo]

Can someone point me to information here or elsewhere online regarding the best procedures to:

take data that is in a single table, and segregate it out into separate tables (legacy FMP 5 pre-table where tables were "simulated")

Merge two (or more) different files into a single file with multiple tables

I haven't had any success trying to search for info on this aspect so far. I have managed to tackle some of the smaller/limited aspects but I have found the broken scripts to be a huge pain.

I am using FMP 10 Advanced, and the DDR reports to reconstruct things where I've made a mess, but are there better steps/procedures than what I'm guessing at?

Can someone point me in the right direction?

Thanks!