summarizing selected data on a grid

[drofnats]

I have a grid that I use to define attributes. I want to
summarize only the selected "types" (i'm just using "x" to
select on my grid). For example, by taking:

A B C
Type1 x
Type2 x x
Type3 x
Type4 x x
Type5 x x

I want to output:

A
Type1
Type2
Type5

With similar output's for B & C. I could do it with if
statements, but it's a pretty big grid, so I have a lot of
blank rows. Is there a better way? Thanks.

 

[AlfD]

Hi!

Have a look at your post: I suspect it has not reproduced as yo
intended. The table of x's doesn't seem to match the script.

Al

 

[Dave Peterson]

It appears ok for me (using a fixed width font).

Maybe you could just apply data|filter|autofilter.

Filter by each column (one at a time) and show just the X's.