Combining two inventories
Bring two lists of references together in one result, in the order they were entered.
Combine the contents of two lists into one result, keep the order of the items, remove duplicates if you wish and get a final list ready to use.
Merge two lists of values without losing their original order. You can keep every occurrence or remove identical duplicates, then copy the list you get.
The tool reads the items of the first list, then those of the second. It trims spaces at the edges of each line and ignores empty lines. By default, duplicates are removed, including repeats inside the same list: only the first occurrence of each identical value is kept. The comparison is case-sensitive. Switch duplicate removal off if repetitions are meaningful. The result is not sorted. Before merging two sources, work out what each line represents: a name, a reference, an answer or a technical identifier. Removing duplicates helps when you want a directory of unique values, but it can lose information when a repeat stands for several real occurrences. If you combine two order logs, for instance, two identical lines may be two different orders; in that case, switch deduplication off. The order is predictable: items from the first list are processed before those from the second. When a duplicate is removed, the first occurrence is the one that stays, which preserves the priority of the first source. Duplicate matching is case-sensitive: “Client A” and “client a” are not strictly identical. Spaces at the ends of lines are trimmed, but variations inside values and typos are not corrected. The result is neither sorted nor checked against an external reference. For data reconciliation, first check formats and input conventions, then use a list comparison tool if you need to separate shared values from those found in only one source. Keep both original lists so you can rebuild the merge. A quick check is to count the useful lines of each input and compare the total with the result. With deduplication off, the number of output lines should equal the total of non-empty lines. With it on, the difference is the number of repeats removed.
Paste one value per line into each field.
Keep or switch off the removal of identical values.
Check the order and any case variants before copying.
Bring two lists of references together in one result, in the order they were entered.
Remove strictly identical answers when you want a list of unique values.
Switch deduplication off to preserve every occurrence when reconciling data.
With the default option on, B, which appears in both lists, is listed only once.
Input
List 1:
A
B
List 2:
B
CResult
A
B
CWith the option off, every line is kept, first from the first list, then from the second.
Input
List 1:
Leeds
London
List 2:
London
YorkResult
Leeds
London
London
YorkThe first list always comes before the second, and the internal order of each list is kept.
Yes, including values repeated within the same list. Switch the option off to keep every occurrence.
Yes. Two values with different case are distinct: “London” and “london” are both kept.
No, they are ignored.
The tool takes two lists at a time. To combine more, merge the first two, then paste the result into the first field together with the next list.
Related tools
Tools similar or complementary to this one.
Compare two lists to find the items they share and the ones that differ.
Sort the items of a list alphabetically or numerically, in ascending or descending order.
Split a long list into groups of a fixed size, based on the number of items you choose.