I have a data set where there are multiple Client Numbers associated with the same Client Name. An example is:
Client Name Client Number 1 Client Number 2 Client Number 3
10 Years 81946
21 Savage (Shayaa Bin Abraham-Joseph) 116290 116288
Aaron Bruch 120062
Aaron Evans pka TA'EAST 85475 108124
Alex Izquierdo (Hia Entertainment) 58161 117956 117873
I want to take this data and convert it into a vertical list that is only two columns wide and the Client Name would be duplicated where there are multiple client numbers. The result would look like this:
Client Name Client Number
10 Years 81946
21 Savage (Shayaa Bin Abraham-Joseph) 116290
21 Savage (Shayaa Bin Abraham-Joseph) 116288
Aaron Bruch 120062
Aaron Evans pka TA'EAST 85475
Aaron Evans pka TA'EAST 108124
Alex Izquierdo (Hia Entertainment) 58161
Alex Izquierdo (Hia Entertainment) 117956
Alex Izquierdo (Hia Entertainment) 117873
Bookmarks