When using Google Sheets table widgets, you may want to ensure that empty columns are excluded from showing on the table.
To do so, locate the table widget you'd like to update on your dashboards or reports. While in edit mode, click on the table widget, then click Data in the sidebar to the right.
Next, scroll to find the 'Exclude Empty Columns' option. Click to open the dropdown, then select Yes. This will update the table widget so that the empty columns are excluded from showing on the table.
Lastly, to lock in these changes, click save in the upper right hand corner of your dashboard or report.