I have a table with two columns containing names (ex: Panagidi/Kyriaki and Panagidi/K).
How can I link the two versions of the name so that they are considered one?
Note, I have other tables (like affiliations) that are linked to either one or the other version of the name
If it is not possible to link the two versions of the name, how should I reformat my table so that I can do what I want with it (for example I want a Top 20 Authors where Panagidi doesn't appear with the first names Kyriaki and K).
Try concatenating those two fields and see .