Combining worksheets

I have an excel workbook with 3 worksheets, all with the same table consisting of the same columns. Each workbook has the capacity to have 20 rows of information filled in.

 I need to be able to copy all the information from each three sheets onto the forth sheet after the corresponding heading.

 However, is there a way to only copy the filled in rows to save large gaps on the forth page?

 Thanks in advance
Shannon CarterAsked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Please watch this short video showing all the steps to get it done.
Though I am using Excel-2013, the steps would be same for Power Query Editing Window except in 2016 the power query is built in under Data Tab. You will be required to find it yourself.

http://www.screencast.com/t/bohvehD7
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
What version of Excel you are using?
If you are using 2010 or later, I would suggest for Power Query to get the desired output.
Please upload a sample workbook with desired output on fourth sheet mocked up manually to visualise the end result.
0
 
Shannon CarterAuthor Commented:
2016, please see attached workbook example
SIMPLE-EXAMPLE.xlsx
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
Shannon CarterAuthor Commented:
Updated with example populated numbers
SIMPLE-EXAMPLE.xlsx
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Please refer to the attached where the data from the three sheets have been extracted on Sheet1 with the help of Power Query.
SIMPLE-EXAMPLE-1.xlsx
0
 
Shannon CarterAuthor Commented:
Can you please explain how you did this?
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
The chosen answer resolved the question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.