Join multiple rows into a single row

[Anonymous]

Hi There,

My Data model as below

Lead	PN	Fac
MK	X1	13
MK	X1	14
MK	X1	15
MK	Y1	13
MK	Y1	14
MK	Y1	16

I'm trying to modify the above into below. 

Lead	PN	Fac
MK	X1	13,14,15
MK	Y1	13,14,16

Its just a sample, I'm delaing with  huge dataset though. Could someone please look into it and help me?

[Anonymous]

Hi Amit,

Thanks for your help. Perfect. That solves the issue. Could you please take a look at the below one

Lets say I've two 13's, is there a way to show just 13,14 (not 13,14,13).

Lead	PN	Fac
MK	X1	13
MK	X1	14
MK	X1	13

Thanks,

Srikanth N

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

concatenatex(Table, table[Fac],",")