I have two spreadsheets which share common elements in one column. The other
columns have different information. I would like to combine them such that
the information in columns are aligned.

As an example: Assume I have associated columns with the values a-z in one
and words beginning in the letters a-z in another and I want to add more
words from two columns on a different spread sheet, let's say one with
letters b, l, n, q, r and asssociated words for these letters in the next
column. I would like the final result to be columns a-z, with the original
associated words and another column with the additionl words in a new column
for b, l, n, q, r. How do I do it?