Concatenate in loop problem

[Anonymous]

I am having a problem to concatenate three fields in a loop to one table.

I am using this code 

let vPrefix = 'NEW:
NOCONCATENATE';

for each i in FieldValueList('GROUP')


for each j in FieldValueList('ELEMENT')

$(vPrefix)

Load
'$(j)' as $(i)
AutoGenerate 1
;

let vPrefix = 'CONCATENATE(NEW)';

next j

next i

and as a result I get this kind of table:

a
b
c
	d
	e
	f
		g
		h
		k

How can I get this table:

a	d	g
b	e	h
c	f	k

[SunilChauhan]

instead of concatenate Join simply and why we need loop.

only thing we should have some key column to join

[Anonymous]

Thanks for quick answer.

I need loops because I must make new table from another table automatically, cannot make any keys manually.

Using a Join function instead of concatenate I get similar mess.