Two columns in Excel, listing the Candidate Id and the preferred city (Just part of it):

```
A B
6957 Ankara
6957 Antalya
6957 İstanbul
6957 İzmir
8469 İstanbul
8470 İzmir
8470 İstanbul
8499 İstanbul
8514 İstanbul
7775 Ankara
7775 Eskişehir
7775 Kastamonu
7775 Zonguldak
7775 Karabük
8532 Ankara
8532 Antalya
8532 Bursa
8532 İzmir
```

How can I make them look like below with VBA:

```
A B C D E F
6957 Ankara Antalya İstanbul İzmir
8469 İstanbul
8470 İzmir İstanbul
8499 İstanbul
8514 İstanbul
7775 Ankara Eskişehir Kastamonu Zonguldak Karabük
8532 Ankara Antalya Bursa İzmir
```