I want to make a spreadsheet that shows multiple book authors and the books
they have written. I want to set it up so that I can sort the list by last
name of the author, but the books they write need to go with their name as it
is moved. I have tried using column A for the author and column B for the
books, but when column A authors is sorted, their books don't go with their
name. I also tried indenting their books under their name with the same
results. The data doesn't have to be in two columns, but their books need to
go with their name. What can I do to make this happen? Thanks for any
advice.