Create a Pivot Table from Multiple Sheets using Power Query
Do you have an Excel workbook (file) that has multiple worksheets of data that you need to combine […]
union
Excel’s VSTACK Function
Combining or appending data from multiple sheets is a common task in Excel. We’ll show you how you […]
SQL Server Union Sorted
This post discusses how you can take a table with a single column of data and add a […]
SQL Server Union
This article is discussing the combining of two or more tables using UNION or UNION ALL into one […]
T-SQL Bulk Insert-Output Part 2
This post continues from our first post T-SQL Bulk Insert-Output of Text Files. Here we will create a […]