Hello Bret

Thank you for your interest in our plugin.

Unfortunately, pulling data from a Google Spreadsheet like this is not possible. wpDataTables would probably pull the data in like that other plugin does.

We don't have support for double headers, or merged cells.

We are going to release a new table type, where you will be able to add data like this in the next couple of weeks. However, those tables would not be editable, filterable, searchable from front-end. You would need to create the table manually, from back-end, and it could only be used for displaying data.

You're welcome, Bret

Glad I could be of service.

If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.