R. L. Dane :Debian:<p>Never could get any of the contacts merge scripts kindly recommended to me by the <a href="https://alpha.polymaths.social/tags/askfedi" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AskFedi</span></a> <a href="https://alpha.polymaths.social/tags/hivemind" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>HiveMind</span></a> to work, but I finally found my own solution, which should hopefully work:</p><p>@libreoffice! ;) (and of course <span class="h-card"><a href="https://mastodon.online/@thunderbird" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>thunderbird</span></a></span>)</p><ol><li>Export contacts from Thunderbird to .csv</li><li>Make a copy of Contacts.csv for safekeeping, I called mine "Contacts-before-jiggerypokery.csv" ;)</li><li>Open Contacts.csv in LO Calc</li><li>Create a key column (A), put "Join" as the label in A1</li><li>Put <code>=TEXTJOIN(" ^ ",1,C2:AM2)</code> into A2 <em>(You may have to replace AM2 with the end of your row if your CSV export has a different number of columns than mine)</em></li><li>Copy that cell and paste it down the entire column A (for every row that contains something)</li><li>Select A1 only, go to Data | More Filters | Standard Filter...</li><li>Make sure your A1 field ("Join") is selected, select "Not Empty" for the value, click "&gt; Options" and select "No duplications" on the right</li><li>Hit Ok</li><li>Copy everything (now de-duped) to a new sheet, delete the old one</li><li>Create another new column (B) just to the right of the "Join" column, call it "Repeat?"</li><li>Paste <code>=IF(TEXTJOIN("",1,C3:D3)=TEXTJOIN("",1,C2:D2),"REPEAT","")</code> into B3</li><li>Copy B3 and paste it down the entire B column (down to the end of the data)</li><li>Look where you see REPEAT, and merge the rows that need to be merged</li><li>Delete Columns A and B (which you added), and save the CSV</li><li>Delete all of your contacts in Thunderbird, and import the new Contacts.csv</li><li>Pray</li><li>Sync your contacts</li><li>Enjoy!!!</li></ol><p><strong>Disclaimer, again: I am still going through my spreadsheet, so I don't know for sure that this works!! XD</strong></p><p><a href="https://alpha.polymaths.social/tags/managecontacts" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ManageContacts</span></a> <a href="https://alpha.polymaths.social/tags/contacts" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Contacts</span></a> <a href="https://alpha.polymaths.social/tags/deduplication" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DeDuplication</span></a> <a href="https://alpha.polymaths.social/tags/degoogled" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DeGoogled</span></a> <a href="https://alpha.polymaths.social/tags/ungoogled" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>UnGoogled</span></a> <a href="https://alpha.polymaths.social/tags/howto" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>HowTo</span></a></p>