I have a "main" sheet like this (which is single words, not compound words):
And I have a compound word sheet like this:
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.