Maybe this is a strange question, but is there a way to add a single row (or several) to the return set of a SELECT statement?Example:I want to populate a drop down list with SELECT EmpID ...

Power Query transformations can assist in splitting data into rows, based on various factors such as delimiter, text patterns, and data types.

Figure A Transfer the Excel Table into Power Query. 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.