Hi, I’m new to Airtable. I have a list of alumnae who have written books, some of which have appeared in our alumnae magazine. I originally created it as a spreadsheet going through the back issues of the magazine and creating a new entry for each new book. This means some authors appeared twice when their books appeared in two separate issues.
What’s the best way to handle this in Airtable? One row per person with columns for Book 1, Book 2, etc (even though the vast majority will have only book 1)? Or a new row each time the author has a new book?