I'm building a spreadsheet to track Certificate of Deposit (CD) rates from various banks. CD rates can be vastly different per bank: term length (3 months, 6 months, 60 months, etc.), and number of different rates (a rate for 3 month CDs and 6 month CDs for one bank, where another bank offers different rates for 1, 3, 6, 11, 16, and 60 months). My question is, how can I track this information in Excel?
Preferably, I'd like to have a row for each bank, as the sheet will need to track other bank information (bank name, URL, etc.). I figured that I'd need one cell to hold multiple values (an array), or an id to another table (such as a relational database).