• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 31
  • Last Modified:

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
0
Shannon Carter
Asked:
Shannon Carter
  • 4
  • 3
1 Solution
 
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
 
Shannon CarterAuthor Commented:
Updated with example populated numbers
SIMPLE-EXAMPLE.xlsx
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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:
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:
The chosen answer resolved the question.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now