I've looked all over for a solution for this but have found no mention of the issue anywhere.
Simply put, I have a report that has a group header and one or more detail results below the header. When exporting as Excel - data only, the format is fine:
Header Result 1
Detail 1, A, B, C
Detail 2, X, Y, Z
Detail 3, 1, 2, 3
etc....
However, when exporting to a CSV file, regardless of the separator character used, the results are as follows (pipe is the delimiter):
Header Result 1|Detail 1|A|B|C
Header Result 1|Detail 2|X|Y|Z
Header Result 1|Detail 3|1|2|3
etc....
Can I make it so the rows keep the report format as shown here?:
Header Result 1
Detail 1|A|B|C
Detail 2|X|Y|Z
Detail 3|1|2|3
-----------

Can anyone help