QUERY Pivot Table -Google Sheets - Query Pivot, Group By, Month, Year Functions Tutorial - Part 6

Video tutorial series about QUERY function in Google Sheets.

In this tutorial we'll cover how to create pivot tables with QUERY function in Google Sheets, how to use month and year functions and also how to create a calculated field using Query function.

Website:

[mizmoman]

Please keep these coming! Every time I watch one of your videos, I learn something that I didn't know was possible with Google Sheets. Thanks for graciously sharing with the rest of us.

[eugeniab]

You are my preferred 'teacher'. Thanks a lot for everything! I always learn with your lessons! I love them, actually.

[negaodoitao]

Great content. Thx for sharing this. Learning a lot!

[ERGODINHO]

10:40 select by year. Very useful tip.

[shanesymons]

Hi there - loving all your lessons they great. Can you please share the sample sheets you using?

[Homunculusregularis]

Thanks a lot! That's really usful :).

[lafamillecarrington]

Having watched this, I now understand pivot tables much better!
I don't understand how I managed without the Query function for so long!

[tounji]

This is awesome! Is there a way to sort the Pivoted columns? Like having the result in this arrangement - > Western, Southern, Northeastern, Midwestern and not vice versa.

[xupgipj]

I've found the way how to replace numbers of the months with names:
(month(A)+1)*30, then format the column that contains months to display months' names

[EduardoBicelisGarcia]

min 05:43 the difference between PIVOT (by columns) and GROUP BY (by rows)... Muchas gracias!

[husseinalayubi]

Thanks for the video! is there a way to display the months as name of month instead of numbers?

[netboy]

We need to pay you for those nice lessons

[hermanwolf]

Google Sheets pivot tables have a 'Pivot date group' function (available in a context menu) that lets me group a column of individual dates by Year-Month, i.e. Jan 2019, Feb 2019, March 2019, etc. Can I do this with a Query?

[juanpauloalmazan]

Good day!, i was wondering if you came across a pivot then somehow it gives an extra column with 0 value label even if my where only limit on the selected week
example, = query(data), select (A)Name, count(A)Name where C = 'WB 02/27/2023' pivot (B) days. it creates a pivot of days within a week and somehow it appears 0 on the last column with value. and sometime if it repeats a column like monday, tuesday and wednesday and then another monday and tuesday again.

[manuvincent]

Everytime I use this, a blank row or colum gets created. Any idea why

[bluepresley]

How do I convert the MONTH numbers to actual dates?

[arturopuentes]

Hi.... Is possible to use a SELECT statement inside SUM in a QUERY function?

[hermanwolf]

Is there any way to show the values of a pivot but hide the pivot column headers?

[annadunskaya]

Hi, is it possible to group by Year and Month without creating additional columns? Like "2020-05 - value, 2020-06 - value..." - all written in a rows?

[MiguelCreteur]

Hi, good video!. Can I sort columns created by pivot sentence in this query, in descent order. (ex.: 2017, 2016, 2015)