Hi Asim,
Thank you for your purchase.

1.

This is like a third time that Google changes something without any information or notification which is very frustrated.

So can you please use the URL link that you get from the browser and see if the issue is gone.

You can find more information on this link.

2.
Can you please tell me does the option include bootstrap.js from wpdatatables settings page is turned on

3. 
Can you please check if you have some "space" in the end of some header name in the file.
For example 
Last Name(space)
That space should be removed.

Hi Asim,

2. Can you disable it and tell me if it is working after that.

3. I asked for permission to see the spreadsheet  let me know when you give me permission.

Thank you.

Hi Asim

About Google Spreadsheet

First I noticed about the Google Spreadsheet is that you have merged cells which is not supported in our plugin.
Also just for your information formulas, functions and empty column headers are not supported when creating tables.

About hidden columns:

Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

Also point me to the table ID so I can take a look.

Thank you.

Hi Asim,

Can you please recreate the spreadsheet without merged cells and tell me if it is working.

Thank you.

Hi dellisn

Google recently changed URL structure and because of that creating wpDataTables from that link is not working anymore. Can you please use link from the browser and not the publish link and then the table will be created. You can take a look at detailed explanation at this link.

Hi dellisn,

You are welcome.

Best regards.