Forum Discussion

Bailey100's avatar
Bailey100
Brass Contributor
May 29, 2019
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...
excel
Excel Online
Formulas and Functions
Bailey100's avatar
Bailey100
Brass Contributor
May 29, 2019

 Haytham Amairah Thankyou! But I don't have this add-on and therefore power query isn't available to me. Is there any other way of solving my problem without the add-on.

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
May 29, 2019

Hi Bailey100,

 

If you have Excel 2016 or later, you don't need the add-in because it's now built in Excel as (Get and Transform Data) as the below screenshot and you can find it in the Data tab.

 

 

If you have an earlier version of Excel, you can download the Power Query Add-in from https://www.microsoft.com/en-us/download/details.aspx?id=39379&CorrelationId=5adf6c76-579e-4bd4-9efe-58c3ddc8a774.

Without the Power Query, the solution could be difficult.

 

  • Bailey100's avatar
    Bailey100
    Brass Contributor
    May 30, 2019

    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

    • Haytham Amairah's avatar
      Haytham Amairah
      Silver Contributor
      May 30, 2019

      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

Resources