Very helpful! I love the A2:N notation to automatically include new rows as they are added and vertical concatenation using { query1 ; query2 }. Our dataset had Player 1 and 2 as separate columns (making up a team). I was trying to summarize points by player as they could compete on different teams. I created Query 1 for Player 1 and Query 2 for Player 2 and then concatenated them vertically using your technique. After sorting I preceded the output with dataset field names using A1:N1. Thanks!!
Thanks for sharing this tutorial , it was very helpful and solved many of my problems in addition to the knowledge of using the QUERY Function in excel appreciated
Is there a way to add an extrda datapoint on that final combined sheet that will tell me what sheet the original data came from? (I can send you a loom if that helps explain my question)
Hello Dana! You get an error because, on your first query, you select the entire dataset A2:N. You can fix this by limiting the number of rows, for example, A2:N18. But yeah, great tutorial as always! Keep it up!
hello Joseph! Nice to see you here again 🤓 oh thank you for pointing that out 🙏 ✨ Glad you enjoy the tutorial 🤘 Thank you again for always being supportive! SL
By the way, @danalyser, how would you combine data from similar worksheets if they where in different workbooks? And, being more precise, the real case is for 100 different worksheets. Thanks!
Selamat Datang! Welcome back and hello if you’re new here! 🙌 Do you think this video is useful ? Any feedback is welcome! 😊
Very helpful! I love the A2:N notation to automatically include new rows as they are added and vertical concatenation using { query1 ; query2 }.
Our dataset had Player 1 and 2 as separate columns (making up a team). I was trying to summarize points by player as they could compete on different teams. I created Query 1 for Player 1 and Query 2 for Player 2 and then concatenated them vertically using your technique. After sorting I preceded the output with dataset field names using A1:N1. Thanks!!
Thank you miss, really helpful for me to excel my proficiency in spreadsheets!!! 👍👍
Glad it was helpful, Andrianto ! 🎉
Thanks! You helped me a lot.
Thanks for sharing this tutorial , it was very helpful and solved many of my problems in addition to the knowledge of using the QUERY Function in excel
appreciated
Thank you Hussein, so glad it was helpful. Thanks for the dataset btw, very helpful for me to put together this tutorial ! :)
Great video!! Thanks
thanks ✅
Thanks!
Thank you for supporting this channel David! 😊
Is there a way to add an extrda datapoint on that final combined sheet that will tell me what sheet the original data came from? (I can send you a loom if that helps explain my question)
Thanks a lot
Happy to help
Hello Dana! You get an error because, on your first query, you select the entire dataset A2:N. You can fix this by limiting the number of rows, for example, A2:N18. But yeah, great tutorial as always! Keep it up!
hello Joseph! Nice to see you here again 🤓 oh thank you for pointing that out 🙏 ✨ Glad you enjoy the tutorial 🤘
Thank you again for always being supportive!
SL
By the way, @danalyser, how would you combine data from similar worksheets if they where in different workbooks? And, being more precise, the real case is for 100 different worksheets. Thanks!
Good, I have a query, how could I subtract or add the previous value of the same column.
This is tricky, don’t think we have this available in Data Studio :)
@@danalyser thanks you
make one video on autmotically data visaultion chart get uopdated when we add adiitoonal data in our google sheets ,,pls make one video over it