This one required some formatting. You need to determine each block of information as its own Unique ID; You also need to figure out which rows in a given block pertain to a given book variable indicated by AB-; TI- etc. Watch out for paragraphs within the TI and AB what contain words with a -, these will throw off the formatting.
Then you pair your unique ID with the actual PMID;
Filter on FAU.
I used summarize by concatenate by ";" and then text to columns (30) splitting this cell.
As a check I measured how many authors were against each book. there's a book with 264 authors; so I capped my columns at 30 and thought that was the gist of this exercise!
