It can be done with a macro. Create a button, attach macro to it. Two options:
1. Use a macro that copies your table, and deletes 2nd coulmn. Requires system access.
2. Create a copy of ypur table which doesn't have column B. Keep it on a hidden sheet. Macro only need to send this hidden table to excel. This is much simpler, no need for system access.