How do I combine worksheets w/o enough rows to combine?

[Amanda W.]

How do I combine 2 worksheets in the same workbook, so that I can create a
pivot chart? The only problem I have is that if I try to manually combine
the two worksheets, I don't have enough rows.

 

[Jacob Skaria]

Amanda

You can create a pivot table with data in 2 worksheets; provided both are in
the same format. From the pivot table >window checkout 'Multiple
consolidation of ranges'

If this post helps click Yes

 

[Debra Dalgleish]

You can create a pivot table from data on different worksheets, using
Multiple Consolidation Ranges, but the results might not be acceptable
to you.

There's information here, and suggested workaround to the limitations:

http://www.contextures.com/xlPivot08.html

 

[Shane Devenshire]

Hi,

1. You can create a pivot table from two or more ranges by using a Union
Query, which may overcome the problems of using multiple consolidation
ranges, but its pretty tricky.

2. A second alternative is to use Access, with or without Excel.

If you tell us more about your data and the pivot table you want we might be
able to pin down the best solution.