I have a "main" sheet like this (which is single words, not compound words):

enter image description here

And I have a compound word sheet like this:

enter image description here

Notice the slightly different columns. How do I combine both lists, aligning them at the custom column, and then sort the result (and ideally so it's non-editable)? I can slightly adjust the columns if necessary.

I would like to do it in the 3rd "full" sheet.

I tried this:


But it doesn't sort them by the custom column, and I'm not sure I have it right.


1 Answer 1


Can you post an example of how you want the columns to allign from both sheets? You'll be able to do it with Sort as you've said, but slightly different depending on how you want to organise the combined content

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.