• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Consolidation of Excel tabs

SAN04

Member
Please suggest way to consolidate multiple excel tabs data in one sheet of the file. Data is in same template in all the tabs.
 
Use Power Query to either Join the tabs or Append the Tabs. Power Query is called Get and Transform Data and is found on the Data Tab on the Ribbon.
 
Back
Top