Forum Discussion
Solved
Extract specific data from numerous sheets to populate one.
How would I go about transferring data from numerous sheets, and condensing it on another sheet depending on whether (on the original sheets) the data has a certain text in a specific column. Her...
Hi,
This is can be done using Get & Transform (aka Power Query).
Please check out the solution in the attached file.
Hope that helps
Hi, Haytham Amairah
Is there any step by step tutorial online that you used for the power query as I have just downloaded the add-in and don't know where to start!
Many Thanks
Bailey100
Hi Bailey100,
I've created a quick video to show you how I've accomplished this task.
Please check it out https://www.youtube.com/watch?v=Go2hYYiizu8.
There are many tutorials online can help you to to learn Power Query, and this is one of them:
https://support.office.com/en-us/article/getting-started-with-power-query-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a
Hope that helps
Haytham Amairah Thanks very much!