You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

A make-table query is what you need.<BR><BR>You can generate a SQL string which constructs a Table (using either existing fields from other tables, new calculated fields, or constant fields).<BR ...