merge data in calc

asked 2020-03-31 23:45:51 +0200

torata gravatar image

updated 2020-03-31 23:50:03 +0200

I have two excel sheets that I want to merge.

The data is a list of vocabulary that I'm learning, so it's a constantly expanding list. Sheet 1 was downloaded earlier and contains fewer words; sheet 2 was downloaded later and includes all vocabulary in sheet 1. The problem is that I've made notes in the cell next to some, but not all of the words in sheet 1.

Basically I want to have the longer list of words (ie sheet 2 data), but keep the additional data from sheet 1 So sheet 1 (apologies, don't know how to get formatting to show a table)

Column A.......Column B

adiós............(blank)

abuelo..........granddad

amigo...........(blank)

... (250 words)

Sheet 2

Column A.....Column B

adiós...........(blank)

abuelo.........(blank)

aeropuerto....(blank)

agua............(blank)

amigo...........(blank)

I've tried the Edit > Track changes > Merge, but that does not seem to do what i want.

This will be an ongoing exercise as I occasionally download the vocab list to excel, so if there's another way to set it up so that it doesn't need merging, I'm happy to try before the list gets longer. The list that I download changes order on a daily basis, so I can't just append to the bottom of sheet 1.

I can think of 3 possible approaches, but don't have the skills to make any of them work: using vlookup; using find duplicates and deleting the row with a blank column B; comparing and merging but using info in column B to take priority in the merge.

Many thanks in advance.

torata

edit retag flag offensive close merge delete

Comments

The list that I download changes order on a daily basis, so I can't just append to the bottom of sheet 1.

I don't know about de-duping, but to combine the lists and sort them using Calc, append the second list to the bottom of the first list, then highlight all of column A and use menu Data -> Sort Ascending (or Descending). That will at least merge the two lists in order by the first column. Hope this helps.

ve3oat gravatar imageve3oat ( 2020-04-01 20:34:27 +0200 )edit