Combining data from two columns into one - appending new values tothe end of one column

J

Jason

Hello--

I have several sheets, Sheet1, Sheet2, Sheet3, etc. Each has a column
of ID numbers in column A, some of which are duplicates across the
sheets. I would like to create a master list of all ID numbers on
another sheet called Master. Is there a relatively easy way to do this
using formulas on the Master sheet? For example:

Sheet1
A
99-1
100-3
500-4

Sheet 2
A
88-4
99-1
500-4
34-9

Sheet3
A
500-4
34-9
51-10
62-9

I'd like the Master sheet to have all of the ID numbers in one column
(the order is not important):
A
99-1
100-3
500-4
88-4
34-9
51-10
62-9

Thanks!
Jason
 
J

Jason

Thanks! I've made the lists but I'm having trouble creating the Pivot
Table in my master sheet. I keep getting this message when I click
Finish to create the pivot table:

"This command requires at least two rows of source data. You cannot
use the command on a selection in only one row...."

What am I missing?
 
H

Herbert Seidenberg

In step 1 of the Pivot Table Wizard
make sure you selected
Multiple Consolidation Ranges.
In step 2b, the three sheet ranges are listed as
defined names.
Insert > Name > Define > Dat1
=Sheet1!$A$3:$B$6
Notice that the range includes a column
to the right of the numbers and a row on top.
I recommend that you start out using my file
as a template, patching your data into it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match and delete rows on two different sheets from reference numbers 4
Group information from several worksheets into one worksheet 1
combining data from multiple worksheets into one 6
Summing one column if two other columns' values appear in other sh 3
index match 3
VLookup to join three + worksheets? 1
Splitting data from one spreadsheet into multiple spreadsheets 2
Transferring data from multiple sheets in workbook to one sheet 5

Top