Combination String in SQL Server

See more:

SQL-Server

Hi all experts,

I have 1 table(Tbl1). it has some fields(TblCode,ItemCode,Name,Name1,qty,Amount)
the data display like this:
1 I0001 Panel B 1 100
1 I0002 Mouse B 1 200
1 I0003 A4Paper C 1 200
1 I0004 Key D 1 10

i want to combine Column Name1 into one string. base on example, it will BCD
Note:
if Name1 is the same, choose only 1. base one example, B has 2 row, but select only 1

What query should i combine string like example?

Thanks

TONY