To follow up on the creating great vocab lists with roots, here's a short work flow (for Mac). Hope it works well for those interested!
1) Find the words you want from Accordance and open them in an Analysis window (this can get complicated – for another post).
2) Prepare a vocab list arranged by root with three columns: Root, Lemma, Gloss
2a) Copy and paste Accordance list into Numbers
2b) Clean up the list so that all you're left with is three columns: Lemma, (Root), and Gloss
2c) Arrange the spreadsheet according to Lemmas so you can see all the word (always the verbs) that only have a Lemma (which doubles as their Root)
2d) Copy and paste those Lemmas and Glosses of those words over one so that the words have a Lemma, Root, and Gloss
2e) Rearrange columns so that the order is Root, Lemma, Gloss
3) Export list into tab files (e.g. for Quizlet)
3a) Remove the parenthesis
3b) Arrange the spreadsheet according to Roots (Numbers can arrange alphabetically in Hebrew now)
3c) Copy and paste // export only the Lemma and Gloss columns into vocab app
End Result: Vocab List with words grouped by Root.
Other options: Add parenthesis to the Roots without them and then merge the Lemma with Roots – Lemma (Root), Gloss. You can also keep the frequency count. In any case I hope this helps!
PS – It would still be great to have the analysis window operate more like a spreadsheet and every word (verbs included) to list a Root. #FEATURE REQUEST
Gordon-Conwell Theological Seminary