how to combine a column values

[Anonymous]

Hi Team,

Need help for the following.

ItemCode	Material
1	A
1	B
1	C

How to transform the above data to following format.

1

A B C

Thanks in advance..   

[Zubair_Muhammad]

@Anonymous

You can use a MEASURE like

Measure =
CONCATENATEX ( VALUES ( Table1[Material] ), [Material], " " )

Then put Item Code and above MEASURE in table visual

[Anonymous]

@Zubair_Muhammad,

Thank you for the quick reply,but its not be the solution.Its just repeat the same value.

Thank you.

[Zubair_Muhammad · Accepted solution]

@Anonymous

Did you use the above formula as a MEASURE?

It works for me. Please see attached file