using csv to import trends into Excel. I want is the same major categories (food/ dining, health/ fitness, etc) to export each month even if there are no expenses.
I export the monthly transactions via the trends page into Excel via csv. If there are no expenses for a given major category i.e. SHOPPING, then that category does not download. So, one month, I may have 10 categories, and the next month, 9 categories. That makes the rows imported into Excel inconsistent month by month and it makes it difficult to average a category over time. For clarity, I'm posting what I'm referring to below.
Food and Dining $100
Financial $0 (and the values of the rest of the major categories)