Aggregate codes from Excel

[#1]

Hello everyone,

I need your help about a development problem.

I have an Excel that is regulary updated. It is composed of a supplier name, and several site.

Each supplier may be present for one or several sites, with a different code (I join you an Excel file for a better understand).

Do you know how can I aggregate all codes behind the supplier name, to automatically get back corresponding data from the several sites ?

I hope I am clear...

Thanks lot for your help

[MarcoWedel]

see Crosstable load in help file

[MK_QSL]

use cross table

DATA:

CrossTable(Site, Data)

LOAD Supplier,

     [Site A],

     [Site B],

     [Site C],

     [Site D]

FROM

[qlik-suppliers (1).xlsx]

(ooxml, embedded labels, table is Feuil1);