Grouping values

[srcapille]

I have two columns of data in Excel:

1. FAMILY CODE

2. NAME

How do i group the lines from NAME Column  by FAMILY CODE

Here is a example:

FAMILY CODE                   NAME
46739723                          ANTONIO CARLOS
46739723                         JOANA MARIA
49643062                          FERNANDA LIMA
49643062                          TENORIO DE CAMPOS
49643735                          ARMANDO FERNANDES
49643735                          ANDERSON ANTUNES

[srcapille]

1. FAMILY CODE

2. NAME

How do i group the lines from NAME Column  by FAMILY CODE

Here is a example:

FAMILY CODE                   NAME
46739723                          ANTONIO CARLOS
46739723                         JOANA MARIA
49643062                          FERNANDA LIMA
49643062                          TENORIO DE CAMPOS
49643735                          ARMANDO FERNANDES
49643735                          ANDERSON ANTUNES

[Vegar]

Try something like this

Load
[FAMILY CODE],
Concat(NAME, ',') AS NAMES
FROM ExcelFile
Group by [FAMILY CODE]
;