Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Working with Databases playlist https://youtube.com/playlist?list=PLNIs-AWhQzclbRVLCZlsFvpz6fz2nPGbt

Get files here https://www.wiseowl.co.uk/vba-macros/videos/vba-ado-net-recordsets/sql-excel-pivot-data/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching!

This video explains how to create crosstab queries in your SQL queries for Excel files. You'll learn how to prepare the base data using a normal Select statement and how to add the Transform statement and Pivot clause to create column groups and aggregations.


Chapters
00:00 Topic List
00:40 The Basic Setup
03:14 Getting Started with a Pivot Query
04:41 Adding a Transform Statement
06:33 Pivoting Column Headers
07:49 Sorting Row and Column Groups
09:26 Adding a Where Clause to the Query
10:42 Specifying Which Columns to Return
11:52 Criteria for Aggregated Values do not Work
13:46 Replacing Nulls with a Value
14:50 Adding Multiple Row Groups
15:55 Grouping on Calculated Values
18:13 Calculations for Column Groups

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more