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?
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)
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 😣
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?
Great
Superb..♥️♥️
OMG thank you so much!
Can you do this on regular data? It seems as it only works when you have created a table data
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?
Same
What if I wanted to add columns to the source data sheets? How would I update the query to reflect the added columns?
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)
This query is picking 10 sheets randomly out of 79 sheets that I want to combine
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 😣
same for me
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?
How do we do same in excel 2013
Is it working for combing of sheets where sheets have different columns?
It takes so much time to load, can you pls advice
What if I have blank cells?
Nice! But when you refresh the table, it will duplicate the values
yes i was about to say the same
How do we avoid that
Can't find 'Blank Query'
How can I do it excel version 2013
For excel 2013 you have to download Power Query
Not coming bro
Great