Resume duplicates (variables) in to one cell

[lilloscar]

In the image I resume a little bit what I need, the names will be different but repetitive, so I need to in to resume in a second cell the names.

 

[Tetra201]

Perform the following steps:

- Make sure you have a column header, such as "Names";
- Go to Data --> Sort & Filter, click 'Advanced';
- In the field 'List range:' enter A:A;
- Click 'Copy to another location';
- In the field 'Copy to:' enter B1;
- Click 'Unique records only';
- Click 'OK'.

 

[lilloscar]

Perform the following steps:

- Make sure you have a column header, such as "Names";
- Go to Data --> Sort & Filter, click 'Advanced';
- In the field 'List range:' enter A:A;
- Click 'Copy to another location';
- In the field 'Copy to:' enter B1;
- Click 'Unique records only';
- Click 'OK'.

Much appreciated, yesterday I was getting mad, and with your answer "Unique records" I googled a better solucion, found a macro and make it work to me like this:

lastrow = Cells(Rows.Count, "C").End(xlUp).row
    
    Sheets("Viajes").Range("C3:C" & lastrow).AdvancedFilter _
    Action:=xlFilterCopy, _
    CopyToRange:=Sheets("Viajes").Range("BK3"), _
    Unique:=True

I don't know if I can say the source but here is my solution.
Thank you

 

[Tetra201]

You are welcome. Glad it worked out for you.