need help

[#1]

hi please help me in this

if i click on the chennai city i should get 11 times chennai city in separate table and same for the remaining citys also can u tel me how to solve that problem

[whiteline]

Hi.

Maybe like this:

LOAD cityno,
     city,
     product
FROM
[wrk12.xlsx]
(ooxml, embedded labels, table is Sheet1)
while IterNo()<=cityno;

[#3]

i should get Chennai 11 times in another table  ,can u tell me how to do

[whiteline]

If you use the script above it creates a table that contains Chennai 11 times.