Diagonalize a Table (Comparing Items in a Crosstab Query)

[baldeagle]

I posted in this section because I don't know a better category.

I have data (from a cross tab report) that looks:


and I would like it to look like:


So that the 'X's make a diagonal.... It helps the humans understand the data better.

I was thinking of exporting the query to excel and then running a script that would look for 'X's in the first column and then move those rows to the bottom. And so forth for each column, until they are in a diagonal like above. (Because the rightmost 'X's are moved to the bottom last).

Am I barking up this tree the wrong way? Does someone know how to do this?

EDIT: I have multiple groups like 'Date' in the above example. Basically for each group I would like it to be diagonal. I also have some groups that use 'Feature A, Feature B, ect' in place of Date, and for those groups I need to leave the rows undisturbed.

 

[llkhoutx]

How do you guarantee that your crosstab will result to be a diagonal?

If you can predict/gurantee that, just manually draw it.

Otherwsie sort of the column be charted.