Тёмный

Centralize Google Sheets tables (QUERY + IMPORTRANGE) 

Radu Popa
Подписаться 4,9 тыс.
Просмотров 45 тыс.
50% 1

Here is a not so complicated way to gather data from diferent tables and put it into a single one. All we need is to mix a QUERY function with several IMPORTANGE functions.

Опубликовано:

 

4 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 28   
@abdullahalmasud3457
@abdullahalmasud3457 2 года назад
Your explanation is top notch! 🔥
@redripper127
@redripper127 Год назад
Thank you very much, this helped me troubleshoot some problems I was having on a project. Much appreciated!
@hpapasutube
@hpapasutube 3 месяца назад
So simple and good explanation! good job!
@sergheyzaporojanu6872
@sergheyzaporojanu6872 Год назад
Hey! thank you so much for the deepdive about this beautiful function. I am curios if it is possible crosslink 2 files between eachother in the same table. I hope I'm not confusing you too much. Basically I have 2 tables: Questions and Answers. And I just want to connect them together. But the challenge is when the row is inserted in Questions table, I am having misaligned response rows from Question table. I'm really curious about this idea since it would allow me a data exchange without oversharing the file where the Experts are answering the questions. I really appreciate your support!
@TheHeatingEngineer
@TheHeatingEngineer 2 года назад
A very useful and well presented tutorial. Thank you.
@adminmangjaja
@adminmangjaja 3 года назад
Great video with simple explanation, good job
@mlqa1929
@mlqa1929 Год назад
Thank you, it was very useful!
@RevimerCCunanan
@RevimerCCunanan 2 месяца назад
Hi! Thank you for this very helpful information. May I know how many files i can combine? is it limited?
@apoorvsom9120
@apoorvsom9120 7 месяцев назад
hi! amazing video man. Thanks a ton. what if the columns are in different order in table 1 & 2, or if there are extra columns that are not common in one or the other sheet?
@Salta-kt3nh
@Salta-kt3nh 7 месяцев назад
Thanks for the explanation. It only seems to work if i do a single cell. When i try to do all cells I require, it gives me the following message "Error Array result was not expanded because it would overwrite data in E2" Do you know what may be the reason?
@PROMOTIONSATSPORTSL
@PROMOTIONSATSPORTSL 5 месяцев назад
Not working showing Error IN ARRAY_LITERAL, an Array literal was missing Values for one or more rows.
@birlodeanu
@birlodeanu 3 года назад
Dear Radu, Must add... sorting on query... show to the people entire think....
@FotonMIS
@FotonMIS 7 месяцев назад
Hi, very useful formula. I have one query though, "col3>0" didn't work on my file, if you could please explain this one please. thank you
@RaviKumar-pr2by
@RaviKumar-pr2by Год назад
Excellent Bro..
@Lil-ym5sn
@Lil-ym5sn 2 года назад
Thank you, I have a question. If I want pull some cells from the sheet and different sheets into summary? I got a huge data contains 100 sheets and all are same in design but the content is different. I would like to summarize these sheets into one page Example: sheet one Sheet1: total of Sells, purchase, cost,transportation Sheet2:total of sells,purchase,cost,transportation How to pull some cells into summary? I want for each sheet one row. Thank you again 💓
@Moonwalker2024
@Moonwalker2024 Год назад
I did exactly the same but if I start to combine the Sheets closer with "Select * where Col1>0",0) ... Google tells me that there is an "Issue while parsing" the Files. It's such a easy code... but what I'm doing wrong?? 🤔
@mkt_2023
@mkt_2023 Год назад
Thank you for the lesson! I have a question..I create a model for documents with hundreds of cell intervals (ex.B2:B2) linked between 1 sheet (imput) and other 4 sheets (ouputs) and I want to use it all with different data. If a create a copy it will create a new link and it should be update for every cell. Is there any way to update the link on the sheets, maybe with a multiple selection? I can't find an answer but I think it should be possible! Thnks in advance..
@HemantVerma-yu8rn
@HemantVerma-yu8rn 5 месяцев назад
Can we consolidate more 8 tan ins single sheet how to consolidate these because more then two query is stop working
@chefibu5347
@chefibu5347 2 года назад
Thanks alot, very informative, how can i sum the value from 2 different spreadsheet into 1 master sheet. For ex: sales of branches in different spreadsheet and sum total of sales in 1 master sheet
@sumayahghamdi5550
@sumayahghamdi5550 4 месяца назад
Thank you so much
@MsElish
@MsElish 2 года назад
Hi, I am using query + importrange to get data from different file, but for few of cells are getting blank. Can you please help me on this
@DumitruDolinta
@DumitruDolinta 10 месяцев назад
hey! will be there anyone who tells how to select not all collumns like "*", bute certain collumns like A,B, and E???
@ninadpawar2062
@ninadpawar2062 2 года назад
Hello how to change data from master sheet when I tried to change,i got an error.
@yogeshshinde-g2s
@yogeshshinde-g2s Год назад
very useful
@feketealexandru9070
@feketealexandru9070 3 года назад
Mult stimate Radu !!! Am dar oarecum întâmpător de canalul tău de youtube , nu am dorit cu ardoare să învăţ excel deoarece eu sun de creo 8-9 ani doar pe linux iar acolo nu este microsoft office (adevărul că şi acolo s-ar putea folosi officeul de la microsoft) dar eu nu-l folosesc din aversitate faţă de orice de la microsoft. Dar bineânţeles există ţi open source pentru excel sub linuc de ex. free office sau mai ales libre office dar mi sunt şi altele . Adevărul că acesre softuri aşa numit deschise şi gratuite diferă de office ul de la microsoft pentru că sunt adaptate oarecum dar eu aş zice că nu este nici o problemă. Eu aş sugera dacă se poate de a face un video cu diferenţele pentru calcul tabelar dintre ele. Ştiu că se poate argumenta că nu are nici un rost pentru că eceste softuri nu sunt bune nu constitue nici o pondere in folosirea lor şi aşa mai departe dar pe de altă parte de ce să nu încurajăm oarecum prin acesta folosirea lor pentru ca lumea să nu folosescă ilicit programe plătite gratis. Mulţumrsc mult pentru înţelegere cer scuze pentru că m-am băgat unde nu-mi fierbe oala. Cu deosebite respecte şi cu mare simpatie Fekete Alexandru din Oradea.
@AhmedGamal-kw6eq
@AhmedGamal-kw6eq Год назад
You don't have permissions to access that spreadsheet.
@creamville63
@creamville63 2 года назад
U did not explain why that ZERO at the end removed the header. So i'm goin to give you a dislike because this is youtube.
@trifavlad-csaba2759
@trifavlad-csaba2759 2 года назад
Buna Radu as avea nevoie de ajutorul tau Poti sa imi dai un contact sa Te pot suna sau sa iti scriu in Privat!!! Multumesc!
Далее
How Many Twins Can You Spot?
00:17
Просмотров 20 млн
Учёные из Тринидад и Тобаго
00:23
IMPORTRANGE Function in Google Sheets | Multiple Sheets
10:11
Master Merging Data in Google Sheets
7:47
Просмотров 34 тыс.
Google Sheets Query Function Explained
12:35
Просмотров 309 тыс.