Is it possible the create something that lets Content Creators create their own tables with differing columns and rows? We have a growing list of products and licenses and need for our content creators to be able to edit tables with products and amounts and also have to ability to add new columns to these tables and add rows as new licenses are created. How would we go about creating something like this?

Do you mean within the context of an RTE property editor?

In general. We're at zero. If RTEs is the way to do it then yes. How would we do it with RTEs? (Rich Text Editors right?)

Think of it this way - treat a product as a unique document type (or maybe an element, depending on how you need to reuse the data). Editors create content nodes, then the front-end can render those as needed. Don't worry about editors creating tables, just let them input data then build the views to suit.

My problem currently is how to 'let them input data' that can be formulated into table data on the page. I simply do not know how to setup a structure that lets them create data with a variable amount of columns and rows. I have experience with Umbraco but I'm drawing blanks thinking about how to set something like this up to be usable and make sense for the creator role. Even my own role. I'm not that experienced with the Umbraco system.