Very Urgent Help required for Qlikview scripting

[#1]

I have data in following format:

Name	Blend	Milled	Unmilled
AA	A12	235	00LK02
AA	av1265	482	507
AA	kl05	kl02	92
BB	BC02Z	KL23
CC	MZ12		7291

IF Name is same then all the respective values for Blend, Milled and unmilled should get in one row(seprated by'/')

How I can make it in following format?

Name	Blend	Milled	Unmilled
AA	A12/av1265/kl05	235/482/kl02	00LK02/507/92
BB	BC02Z	KL23
CC	MZ12		7291

Thanx in advance..

-Pradnya

[rwunderlich]

LOAD Name,

     concat(Blend,'/') as Blend,

     concat(Milled,'/') as  Milled,

     concat(Unmilled,'/') as Unmilled

FROM

[http://community.qlik.com/thread/76151?tstart=0]

(html, codepage is 1252, embedded labels, table is @1)

GROUP BY Name

;

-Rob

http://masterssummit.com

http://robwunderlich.com