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

Resources