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 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!