I have a list that contains duplicates, unique names and blanks. I want to create another one with the duplicates and unique names and no blanks. Column AH won’t expand much beyond row 15.

AF AH
4 Customer 1 Customer 1
5 Customer 4 Customer 4
6 Customer 2 Customer 2
7 Customer 3 Customer 3
8 Customer 4 Customer 4
9 Customer 5 Customer 5
10 Customer 6
11 Customer 7
12
13
14
15
16
17
18
19
20 Customer 1
21 Customer 4
22 Customer 2
23 Customer 3
23 Customer 6
24 Customer 7
25
26
27
28
29
30
Continues 243