How to Create a Table From Query Results in Microsoft SQL. If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results.

How to add a new column in Power Query Our goal is to combine the t-shirt sales by client into a single cell for each client. Doing so entails grouping by the clients.