Listbox Problem

[#1]

I have included the following file and would like to create two list boxes with the Alt  and Top Criteria column names listed and in the list box. Something like so:

Alternates               Top Level Criteria

Alt1                                   1

Alt2                                   2

Alt3                                   3

Alt4                                   4

Alt5                                   5

Alt6                                   6

Alt7                                   7

Alt8                                   8

Alt9                                   9

Alt10                                10

Alt11

If possible, I was wondering if there was an ability to select either the Alternate or Top Level Criteria and get a display of the respective data.

[hic]

You should load this data using a Crosstable load, e.g.

CrossTable(Alternates, Data, 2)

LOAD [Top Level Criteria],

     [Sublevel Criteria],

     [Alt 1],

     [Alt 2],

     [Alt 3],

     [Alt 4],

     [Alt 5],

     [Alt 6],

     [Alt 7],

     [Alt 8],

     [Alt 9],

     [Alt 10],

     [Alt 11]

FROM [chicklet_example_scratch.xlsx]

(ooxml, embedded labels, table is [Numeric Translation]);

See more on The Crosstable Load

HIC

[sasikanth]

Try this

Pls. fina the attachment

[Chanty4u]

may be

[sunny_talwar]

Use a CrossTable Load here:

Table:

CrossTable(Alternative, Data, 2)

LOAD [Top Level Criteria],

    [Sublevel Criteria],

    [Alt 1],

    [Alt 2],

    [Alt 3],

    [Alt 4],

    [Alt 5],

    [Alt 6],

    [Alt 7],

    [Alt 8],

    [Alt 9],

    [Alt 10],

    [Alt 11]

FROM

chicklet_example_scratch.xlsx

(ooxml, embedded labels, table is [Numeric Translation]);

[#6]

Henric,

I'm sorry, but I would like to know the above based on only the Combined data sheet in the attached file.

Thanks Again,

Preston

[#7]

Sasi k,

Thanks on the quick reply, but I would like to know the above based on only the Combined data sheet in the attached file.

Thanks Again,

Preston

[#8]

Chanty 4u,

I'm sorry, but I wasn't specific enough in the initial post. I would like to know the above based on only the Combined data sheet in the attached file.

Thanks Again,

Preston

[#9]

Sunny T,

Thanks again for a speedy reply! I remember you helping me on the CrossTable load before, but my management wants to use the Combined data sheet in the attached file to get the initial layout I posted above. Do you have any idea how I could get it done?

Thanks Again,

Preston

[sunny_talwar · Accepted solution]

Try this:

Table:

CrossTable(Alternative, Data, 2)

LOAD [Top Level Criteria],

    [Sublevel Criteria],

    [Alt 1],

    [Alt 2],

    [Alt 3],

    [Alt 4],

    [Alt 5],

    [Alt 6],

    [Alt 7],

    [Alt 8],

    [Alt 9],

    [Alt 10],

    [Alt 11]

FROM

chicklet_example_scratch.xlsx

(ooxml, embedded labels, table is Combined);