Forum Discussion
MOVE DATA FROM DIFFERENT SHEETS AND TO COMPILE IT IN ONLY ONE TABLE
HI Charly727,
Power Query is the best solution for your answer, You can convert all you sheets into Excel Tables or open power query select the location of your current excel file and then move use the Power Query to combine the information.
This video link might be helpful - https://youtu.be/F5fjv6nXvZo
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
Hi Faraz,
I have followed the explanations in you video and I have one problem with the updating.
When I try to update the power query. Old data are maintained in the power query sheet , even if I delete one sheet the power query after updating maintain those data
Can you help please? It is an important project for me and I am confusing how to repair it
Carlos
Hi Charly727
OK, so here is the game..
Basically power query is ETL tool which means it will
Extract the information from your source file like XLSX,TXT,CSV,PRN etc
Transformation is the query editor, where you combine, make changes, shape you data
Load is finally once your are satisfied with your transformation load it to your workbook/date model and do your stuff.
Note : If you make any changes to your source file & hit refresh it will reflect the changes in the query file. example as you said when you deleted the file it deleted the information from the query file as well.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert