So the only alternative I could find was to scroll to the bottom of the library. Then select all on the page and copy into a text document.
This text document can then be pasted into a spreadsheet, blank rows removed, and re-sorted as necessary:
- Add column to left with numbers ascending
- Sort by column B ascending + column A ascending - this will group together all blank rows
- Delete blank rows, then sort again by column A
- Delete contents of column A, then put in formula in cell A1 of "=B2" (no quote marks)
- Copy this down
- Authors are now in column A, titles in column B
As authors are in <firstname, lastname> order, it's not as easy to go through them. This formula in the next column pulls out the surname:
=TRIM( RIGHT( SUBSTITUTE( A1 ; " " ; REPT( " " ; 100 ) ) ; 100 ) )
Posts
