How to store one-to-many records in Excel?

Question

excel

How do you store records that can have a large, potentially infinite, number of children? For example, "list of clients --> dates of calls with each of them". I don't know in advance how many calls each will make. Maybe hundreds, maybe tens, and with someone there can be 5 pieces

. I don’t consider third-party services and other software. The question is only about Excel.

Desktop version of Excel.

Answer 1

Regular table, call log type: Client|Call date. If it is typed manually, then it would be good to make a separate list of these clients so that the values ​​\u200b\u200bare selected from the drop-down list in the log, otherwise there will certainly be mistakes. According to such a table, you can always make an analysis / report either manually or as a pivot table.