How to Combine the data which is other rows in Same SQL Table [duplicate]

This question already has an answer here:

• Simulating group_concat MySQL function in SQL Server? 8 answers

SQL - joining records from same table

I have data in a table and I need to simply the big table into smaller one version of table by reducing duplicated rows the concat data into rows.

Here is my base table:

BW  SPEC    BAND    PORT    MODE    VC  TC  DOMAIN  BLOCK
---------------------------------------------------------
-   SNDR    1      see_b    umts    VC1 TC1  SVB      rx1
-   SNDR    2      see_b    umts    VC1 TC1  SVB      rx1
-   SNDR    3      see_b    umts    VC1 TC1  SVB      rx1
-   SNDR_2  4      see_b    umts    VC1 TC1  SVB      rx1
-   SNDR    5      see_b    umts    VC1 TC1  SVB      rx1
-   SNDR    6      see_b    umts    VC1 TC1  SVB      rx1
-   SNDR    8      see_b    umts    VC1 TC1  SVB      rx1
12  SNDR_2  9      see_b    umts    VC1 TC1  SVB      rx1
12  SNDR_2  29     see_b    umts    VC1 TC1  SVB      rx1

I want to combine data which present in BAND:

Based on BW Spec PORT MODE VC TC DOMAIN BLOCK for example

Thanks in advance

enter image description here