Combine data from multiple sheets into one #exceltip

Показать описание

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😁.

Рекомендации по теме

Комментарии

Which excel version this is ??? I am useing 2016 will this work ???

Suma-qhnn

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?

hitendrasinghshekhawat

What if I wanted to add columns to the source data sheets? How would I update the query to reflect the added columns?

Beemerbmr

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)

theamateur

Can you do this on regular data? It seems as it only works when you have created a table data

allara

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 😣

kw

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?

AnkitKamli