How to reorganize a table

[mah]

Hello,

I have a table like that :

customer	prod_1	prod_2	prod_3
customer_1		green
customer_2	red		orange

and I would like to count customer by product to get a table like this : 

product	count	custumer
prod_1	1	customer_2
prod_2	1	customer_1
prod_3	1	customer_2

Is it possible ?

[gcusello]

Hi @mah,

please try something like this:

your_search
| stats count BY product customer
| table product count customer

Ciao.

Giuseppe

[richgalloway]

What search produced the first table?