How to form a table from 2 listboxes containing different attributes

[Anonymous]

I have 2 listbox containing these values.

Listbox1
NAME
ADDRESS
TELEPHONE

Listbox2
ALEX
JOHN
EMILY
New York
London
Trenton
8923492929
8234234334
3434392929

I need to form the table like this:

NAME	ADDRESS	TELEPHONE
ALEX	New York	8923492929
JOHN	London	8234234334
EMILY	Trenton	3434392929

I could only separate the rows of listbox1 using

LOAD listbox as NAME  FROM [./address] where listbox1 like 'NAME';

How can i separate rows of listbox2? Any ideas?

Thank you

[sunny_talwar]

What is the source of your data? This is something you would want to resolve in the script, right?

[Anonymous]

Hey.. Sorry I was not clear about my source of the data. My source was from an xml file which i then added into excel to look like this because it seem more better for me.

I  think i found the answer from this post Converting rows into multiple columns | Qlik Community which worked for me.

Though I have a question. I am attaching my sample excel file which is similar to this one and I want to group the data in the format like this.

ID	NAME	GROUPS
123	William	1
123	William	23423
12314	RAJ	1
12314	RAJ	312
12314	RAJ	34
12314	RAJ	3242
23232	John	32
23232	John	43223
23232	John	122344
23232	John	1321

Load RowNo() as link, A as [ID]

FROM [SAMPLE>XLSX](ooxml, no labels, table is Sheet2)

where B = 'ID';

Left Join LOAD RowNo() as link, A as [NAME]

FROM [SAMPLE>XLSX](ooxml, no labels, table is Sheet2)

where B = 'NAME';

I was able to join the ids and names using above method but since there are multiple groups, this technique is not working for groups. Can you suggest something?