Is there a way to export reports where the column data is repeated for each transaction
Options
schodorf
Member ✭✭
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.
0
Best Answer
-
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.6
Answers
-
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.6
This discussion has been closed.