list box (?) for data cross several columns

[#1]

Extreme noob here, please bear with me.

I need to analyze similar data across several columns:

Shopper	Product 1	Product 2	Product 3
1	Apple	Orange
2	Banana	Apple	Orange
3	Orange

How can I create a List Box (or other object) to capture the data across the different columns?

Product Type	Count
Apple	2
Banana	1
Orange	3

Many Thanks, Frank

[maxgro · Accepted solution]

t:

LOAD Shopper,

    [Product 1],

    [Product 2],

    [Product 3],

    F5

FROM

[http://community.qlik.com/thread/154159]

(html, codepage is 1252, embedded labels, table is @1);

t2:

load Shopper, 1 as ProductNumber, [Product 1] as Product Resident t where len(Trim([Product 1]))>0;

load Shopper, 2 as ProductNumber, [Product 2] as Product Resident t where len(Trim([Product 2]))>0;

load Shopper, 3 as ProductNumber, [Product 3] as Product Resident t where len(Trim([Product 3]))>0;

then add a straight table chart

see attachment

[#3]

That solves it. Thank you Massimo !