Hi @dcsearle Thanks for reaching out!
One option is to create a different table for each possible sheet & then show/hide the tables dynamically. This allows you to configure the tables for each possible scenario. To place multiple components in the same spot on the cavas, make sure all but one are "hidden" at any given time.
Another option is to use dynamic column settings. You enable this under Content->Advanced. Then, delete all columns from the Content->Columns section since they'll instead be created dynamically
