Crosstab - Repeating Row labels for export to Excel

[DiggerDog]

hi
I have created a crosstab report and wish to trepeat the row labels so there is a value in every filed in every row when I export it to Excel

E.g I want
C1 C2 Total
Row A RowB 1 3 4
RowB 3 4 7
Total 4 7 11

To export to excel and look Like

C1 C2 Total
Row A RowB 1 3 4
Row A RowB 3 4 7
Total 4 7 11

 

[lbass]

You can either concatenate the two values to use as a single row field, although these will then appear in the same cell, or you could try reversing the rows. If there is only one instance of Row A for each instance of Row B, then both labels will appear. In Excel, you could then move the column to its correct position.

-LB