Тёмный

Combine data from multiple sheets into one  

Let's Learn Data!
Подписаться 2,1 тыс.
Просмотров 312 тыс.
50% 1

Hey guys!!! Thanks for watching. I'm trying to grow my channel so I'll appreciate any feedback from you all.
Don't forget to like and subscribe😁.

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

 

1 окт 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 25   
@hitendrasinghshekhawat8461
@hitendrasinghshekhawat8461 Год назад
it's not working for me, instead of tables it's showing error in query screen after applying formula "excel current workbook". can someone help please?
@flywith5505
@flywith5505 10 месяцев назад
Same
@theamateur6971
@theamateur6971 6 месяцев назад
Thanks, please help. Its not picking up all the data (shows null in some cells, the null values represent different values so i can't replace null with only one value)
@kw9568
@kw9568 Год назад
For some reason it's not combing the data within the existing workbook. For example you have Mexico, France, US, and Germany combined in your master. For some reason when I follow these steps it's combining data from other tables but it doesn't appear to be the data from the existing workbook. Please help 😣
@hitendrasinghshekhawat8461
@hitendrasinghshekhawat8461 Год назад
same for me
@Suma7777-qh4nn
@Suma7777-qh4nn Месяц назад
Which excel version this is ??? I am useing 2016 will this work ???
@Pushpa-jo5gp
@Pushpa-jo5gp 2 месяца назад
Not coming bro
@nanazesh
@nanazesh 3 месяца назад
Great
@Beemerbmr
@Beemerbmr 3 месяца назад
What if I wanted to add columns to the source data sheets? How would I update the query to reflect the added columns?
@tanviananth7464
@tanviananth7464 5 месяцев назад
It takes so much time to load, can you pls advice
@AdekolaAderoju
@AdekolaAderoju 10 месяцев назад
This query is picking 10 sheets randomly out of 79 sheets that I want to combine
@AnkitKamli
@AnkitKamli Год назад
Can you solve it. I had a pdf file with multiple pages, and I wanted it into word file. I converted it online and I have now word file. But problem arrised when I tried to align, as file having data inside tables format. There were hidden tables in word file and so I wasn't able to merge all of it at once, as different data in different boxes. I tried to do with simple method "Alt+J+L+M" but that's time consuming for multiple pages. So is there any other way I can do it fast?
@ronamyzacarias4110
@ronamyzacarias4110 3 месяца назад
What if I have blank cells?
@the3adonis
@the3adonis 10 месяцев назад
Can't find 'Blank Query'
@allara5613
@allara5613 8 месяцев назад
Can you do this on regular data? It seems as it only works when you have created a table data
@jsaha23
@jsaha23 Год назад
How do we do same in excel 2013
@bhanurajput6574
@bhanurajput6574 2 года назад
How can I do it excel version 2013
@letslearndata9447
@letslearndata9447 2 года назад
For excel 2013 you have to download Power Query
@Dzek007
@Dzek007 2 года назад
Nice! But when you refresh the table, it will duplicate the values
@catshometown5683
@catshometown5683 Год назад
yes i was about to say the same
@chasityj.4130
@chasityj.4130 Год назад
How do we avoid that
@rachitgupta6202
@rachitgupta6202 2 года назад
Is it working for combing of sheets where sheets have different columns?
@rwfrench66GenX
@rwfrench66GenX Год назад
OMG thank you so much!
@umamaheswari4194
@umamaheswari4194 Год назад
Superb..♥️♥️
@Hemanthburram1998
@Hemanthburram1998 2 года назад
Great
Далее
# Rural Funny Life Wang Ge
00:18
Просмотров 774 тыс.
Link Every Worksheet to a Master Sheet in Excel
6:05
Просмотров 811 тыс.
EASILY Make an Automated Data Entry Form in Excel
14:52
How to Move Data Automatically Between Excel Files
11:37