Merge Two Collections

How To... > Work with Collections > Merge Two Collections

There are two situations in which you want to make one collection out of two: The collections have the same attributes but different cases (two students collected the same kind of data from different people or experiments), or the collections have the same cases but different attributes (each case is a state or province, and you want all the attributes from both collections brought together).

The second situation breaks down further, depending on whether the cases are in the same order in both collections. When cases are in the same order (planets from Mercury to Pluto), you can copy and paste the attributes from one collection to another. When they aren’t in the same order, or you aren’t sure, you can use the Table Join feature using case tables. For this last situation, you first need both collections to be in the same document (copy a collection in one document, and paste into the other). See Add Attributes from Another Case Table Using Table Join.