In this class we will learn how to transform a single column into several columns using the QUERY function, in this case we will take the rows and transform them into columns using the dates, separating and grouping them by month with the query function within Google Sheets. 👉Link to the Spreadsheet: https://docs.google.com/spreadsheets/... 👉How to make a copy of the Spreadsheet: 🔴 • ✅EASY - Copy Google Spreadsheets that... If you want to master the QUERY function, I advise you to see a Playlist with several classes where I explain different ways to use the QUERY function to greatly optimize our time and work more fluidly in a database. Playlist QUERY: 🔴 • QUERY - Mastering the function more power... Sometimes we need some functions to complement our objective and for that there are many possibilities, it is also possible to do something similar with the FILTER function where we can pull through a DROPDOWN menu the data (dates) we want but it is not possible to do the sum or any calculation directly with it. Filter function - FILTER by MONTH in Google Sheets: 🔴 • Filter function - FILTER by MONTH in Go... We often have to press CTRL C and CTRL V to copy some data from other tabs but now with this formula it becomes automatic each time some data is added to another tab. This way we have a more dynamic and automated spreadsheet, avoiding repetitive and boring work that requires a lot of time and labor on a daily basis. The query function is very powerful and we can perform several data treatments with it, there are some video classes here on the channel about it and many arguments that we have already covered in other video classes. Pull REPORT BETWEEN DATES with the QUERY function: 🔴 • Pull REPORT BETWEEN DATES with the function... It is also possible to pull data and group data by making a sum with the query function widely used to help and optimize our Google spreadsheet, bringing the grouped values as we need. How to GROUP SUM within the QUERY: 🔴 • How to GROUP SUM within the QUERY (Su... There are many resources within Google Sheets that can help you in different ways, in addition to sharing a spreadsheet, it is also important to learn basic functions in Google Sheets so that you better understand the dynamics and become more familiar with these functions that we will gradually combine with other functions and form formulas that will help a lot in our daily lives - Basic operations ... Remembering that all the links. The important things will always be here in the description for better learning and access to documents and video class handouts. in exclusive content from Google Sheets, subscribe so you don't miss any new video lessons on the channel! Playlist Link to Master Google Spreadsheets: 🔴 • How to pull data from other tabs in the spreadsheet... Teaching from scratch to advanced Google Spreadsheets, Google App Script and Data Studio, with tutorials, step-by-step Google Spreadsheets, step-by-step data Studio and Google App script walkthrough. So if you want to learn about Google spreadsheets once and for all, you've come to the right channel, subscribe and follow all the video lessons on the channel. A big hug and success in the spreadsheets!!! Chapters: 00:00 - Introduction to the class on how to transform rows into columns #GoogleSheets #GoogleSheets #GoogleSheets #QUERY