As mentioned earlier by CWatkinsNash, the process is fairly straightforward. I sorted by tags (remember, I had previously edited them down to MY limited selection. I then highlighted each group of tags and edited in my tag into the freshly created TagsGM column. It shows up in the category browser and the work of a couple of hours had me where I asked Kiwidude to get me. I de-listed the old Tags column from being on view. Done.
I did have to make a scripting change.
My GENRE column now has this script:
{#tagsgm:re( *(.[^\,]?)[^\,]*?(\,|$),\1\2)}
NOTE: #tagsgm replaces tags
My Plugboard for my Kindle2 (actually 3) shows:
[{#readrank:ifempty(0)}{#genre:ifempty(SF)}] {#stripped_series:lookup(.\s,#initials,.,#shortene d,series)}{series_index:|-|-}{title}
IF YOU COPY THIS and get an error in calibre, check shortened is all one word and that there is no space before the d.
The ReadRank column is a set column giving me 1 thru 9. I honestly only use 1,2,3 for books I want to read and export to the Kindle. The two ifempty checks are in case I have a blank field for ReadRank (make it 0 so it shows up right off the bat) and a blank tag is almost assuredly going to be an SF title. The Stripped Series, Initials and Shortened Series calculated column scripts are all from others in this forum, most notably CHaley.
This results in titles like [1AN] New Yorker - Bernie Madoff Profile - Jeffrey Toobin, [1Br] MLaw-12-The Two Over One Bidding Book - Mike Lawrence, [1My] MA-1-Summer of the Big Bachi - Naomi Hirahara, [2SF] Cowboy Angels - Paul Mcaulay, etc.
I can sort by title and get my books listed in the desirability rank, then genre, then series, then title. No need for collections. I just pick a mystery from the 1's, then a SF book from the same rank, then something else ... bridge, sports, non-fiction, etc. Then repeat. As I add new books that I want to read fairly soon, they migrate to the 1 section immediately, so I'm always picking the cherries. Lower rankings denote books that I suspect have a flaw as far as my interests go, but have gotten good enough reviews to be a button push away. And the rank 3's are old favourites that I like to have around when I want something quick, familiar and unchallenging. I have more than a few books in calibre that aren't rated yet and might not ever see the light of a Kindle screen. Like the ones my Mom likes
At any rate, now you can see why I wanted limited tags.
GM