nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Exporting report data to an Excel spreadsheet - how to get "date" on each transaction ?

markstehm

When I export data from a report to Excel, I often have multiple entries per date. The date appears only on the first entry. I want the date repeted on for every item so that I can do my own sorting and summarizing. Is there any way to make the exported version of the report export everything as data rather than as a report with all the report formating?

Find more posts tagged with

Reports

Accepted answers

Jim_Harman

It is a bit clumsy, but see this discussion

https://community.quicken.com/discussion/7882563/attribute-values-missing-for-split-transactions-in-reports

markstehm

Jim_Harman - This method and it's related comments tells me that this is a known problem and the proposed workaround is truly clumsy, as you said. That solution works OK for large blocks, but if you have a couple hundred rows with many occurences of "data follwed by 2-3 blanks", "data follwed by 2-3 blanks", etc, then it is easier to just do Select and then Ctrl and drag.