Hello Joshua.

Thank you for your purchase.

I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.

When you use a file as an external file source, wpDataTables only reads the values, and it doesn't copy any formatting, formulas, merged cells, etc. Same goes for importing those files.

If that Excel file doesn't contain any confidential info, could you please send it to us, so that we can look for any workarounds for you?

You can attach it to your reply, just make sure you enable the PRIVATE slider, since this ticket is public; so that it is only visible to us.

Best regards.

Hello again Joshua.

After taking a look at these two files, I am sorry to inform you that it's impossible to create tables from these files.

Our plugin can only accept simple tables without formulas. You'd need to create a simple table and then use formula columns and calculation functions to make it resemble these two tables. Also, you'd probably need Powerful Filters for those dropdowns, that'd enable cascade filtering and create tables similar to these.

I am sorry for any inconvenience.

Best regards.