I have data that are 1 to many relationship.
For eg, The book with the same title can be in multiple locations and i would like to find out the information related to the user borrowing in multiple locations - both the user information + the respective multiple locations information.
How do i organise the data in excel so that i can still analyse and also able to extract data easily ?
Prob now is for eg. i have a row but also multiple row that is pertaining to the same book title so it would be very misleading to count the number of rows to get the total number of books borrowed since some rows are like "repeated" and not the actual unique data.