How to "Un-normalise Data in multiple related table, into one Excel sheet

[swinster]

For Excel 2016

OK, so I have a SQLlite.db file, which I can export three related tables as individual CSV files.

What I'm ultimately after is a way to extract data from these multiple tables and re-combine it as an "unnormalised" dataset in a single sheet. Hopefully, I can automate this procedure in Excel. The purpose is to recover a broken system, to re-import data back into a new system, but unfortunately, the Import GUI mechanism requires a single, unnormalised data set.

What is the best method to achieve this? Are there any inbuilt tools (or otherwise) to help? Of course, most data manipulation goes the other way, to create an unnormalised data set into related and separate tables.

Thanks for your input