Are you creating the query in the same workbook? Do it fast and efficiently!

[@dwightroberts5031]

I’ve come across similar situations several times recently. I made multiple queries as you first suggested, but I knew there had to be a better way. Thanks for sharing!

[@alejandrahorvath]

Glad you found this useful. Thanks for watching 😊

[@rick_.]

Always with how concise your queries are!

[@alejandrahorvath]

Thanks for watching 😊

[@luismiras6481]

Alejandra eres sensacional, como disfruto de tus videos. Son especiales y tienes una manera tan pedagogica para enseñar que da verdadero placer aprender contigo. Saludos desde Argentina.

[@alejandrahorvath]

Muchísimas gracias por tus palabras tan lindas, no sabes cuánto aprecio tu apoyo!!! Saludos hasta Argentina!!!

[@mathewrtaylor]

This is great, I love watching your magic in power query! Thanks for sharing this!

[@alejandrahorvath]

Glad you enjoyed it! Thanks for watching 😊

[@eduardomunoz2764]

Magistral, cada video un deleite de conocimiento para el lenguaje M. Gracias Ale, saludos y un abrazo.

[@alejandrahorvath]

Muchísimas gracias Eduardo!!! Te mando un fuerte abrazo 😊

[@ziggle314]

Thanks Alejandra! Nice work. Good reminder about the problem of a new worksheet referencing itself.

[@alejandrahorvath]

Glad you liked it!! Yes, it's so easy to forget that the new worksheet is also being transformed. Thanks for watching & have a great rest of the weekend 😊

[@kebincui]

Brilliant as always, Thanks Alej and keep up the good work like this 👍

[@alejandrahorvath]

Glad you liked it Kebin! Thanks for watching 😊

[@bentatlim]

Great understandable explanation 👍 Thank you very much - I'm very curious about new videos

[@alejandrahorvath]

Glad you liked it! It's my pleasure to share. Thanks for watching 😊

[@WJRobbins125]

Thank you! I was just working to figure this out at work last week. :)

[@alejandrahorvath]

Glad you found it useful! Thanks for watching 😊

[@alexrosen8762]

Your tutorials are always useful 👌

[@alejandrahorvath]

Glad to hear that! Thanks for watching 😊

[@Luciano_mp]

Great, thank you!

[@alejandrahorvath]

Glad you liked it. Thanks for watching 😊

[@countryboy_71]

A great video to solve a common problem! One question though. Following along, PQ(get data) won't allow me to import a file 'being used by another process'. How did you get yours to do that?!

[@alejandrahorvath]

If you follow the steps as I show in the video, you should be able to make it work. I'm wondering if it has to do with the Excel version. I'm using Microsoft 365, which version of Excel are you using?

[@countryboy_71]

@@alejandrahorvath, found the problem. I had the files save in one-drive. Moved them to a local folder on my HD and it is working as expected now. Thank you!

[@alejandrahorvath]

I'm very glad to heard that! Thanks for letting me know. Cheers!😊

[@joselencinamalgor6548]

Nice solution! Ahorrando pasos. Gracias. Where is🐱?

[@alejandrahorvath]

Me alegra que te haya gustado José! 🐱is sleeping 💤💤💤

[@ccentermanager]

I am trying to repeat each step, but when I select data from the excel file which is the same that is open (Solved.xlsx) excel shows an error that it can´t connect because is being used .!! how can i solve this??

[@alejandrahorvath]

Are working in OneDrive? You may need to save the file in your hard drive.

[@juanlunadelgado6230]

EXCEL LENTE. PORFA EN ESPAÑOL Saludos desde PERU

[@alejandrahorvath]

Muchas gracias Juan! El tiempo no me ha permitido crear contenido en Español, pero regresaré a los en vivo. Saludos 😊