Exporting report data to an Excel spreadsheet - how to get "date" on each transaction ?
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?
Best Answers
-
It is a bit clumsy, but see this discussion
QWin Premier subscription0 -
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.
Thanks for the help. It's not the answer I hoped for, but at least now I will stop wasting time looking for a Quicken solution.
0 -
The .csv option is in the report's Print dialog.
Every report has this, but sad to say, Splits don't get the date on each line.
Quicken user since version 2 for DOS, now using QWin Biz & Personal Subscription (US) on Win10 Pro.
0
Answers
-
It is a bit clumsy, but see this discussion
QWin Premier subscription0 -
Export to a .csv or .txt file and each line should contain the date.
Quicken user since version 2 for DOS, now using QWin Biz & Personal Subscription (US) on Win10 Pro.
0 -
There is no .csv option and .txt does not repeat the dates as desired.
0 -
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.
Thanks for the help. It's not the answer I hoped for, but at least now I will stop wasting time looking for a Quicken solution.
0 -
The .csv option is in the report's Print dialog.
Quicken user since version 2 for DOS, now using QWin Biz & Personal Subscription (US) on Win10 Pro.
0 -
The .csv option is in the report's Print dialog.
Every report has this, but sad to say, Splits don't get the date on each line.
Quicken user since version 2 for DOS, now using QWin Biz & Personal Subscription (US) on Win10 Pro.
0 -
OK, so I found that option, but Splits are the biggest problem so this option won't solve the entire problem.
Thanks for the follow-up.
0