Community Homepage
Discussions
Categories
Quicken for Mac
Quicken Lifehub
Quicken Mobile
Quicken on the Web
Quicken for Windows
Support
Quicken Classic
Quicken Simplifi
Getting Started
Community Training FAQs
Using and Improving the Community
Connect and Engage
Announcements & Alerts
Announcements
Alerts, Online Banking & Known Product Issues
Product Ideas
Beta
Home
Quicken Classic for Mac
Reports (Mac)
Is there a way to export reports where the column data is repeated for each transaction
schodorf
When exporting a report into a spreadsheet, the categories are rolled up at the top of many transactions. I would like to have all the data associated with the transaction repeated for each exported line. This allows pivot tables on categories, etc and better analysis.
Find more posts tagged with
Accepted answers
John_in_NC
I do not know of ways to massage the data that gets exported from reports to CSV format.
I don't know what you are trying to do, but if you export transactions directly from the register (versus running reports), then each transaction will have all the fields populated as they are in the register. Splits can be cumbersome though as you get a separate line for each child line. But, exporting the raw data out of your register might be more ideal if you wish to manipulate with pivot tables.
All comments
John_in_NC
I do not know of ways to massage the data that gets exported from reports to CSV format.
I don't know what you are trying to do, but if you export transactions directly from the register (versus running reports), then each transaction will have all the fields populated as they are in the register. Splits can be cumbersome though as you get a separate line for each child line. But, exporting the raw data out of your register might be more ideal if you wish to manipulate with pivot tables.
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Best Of