Taking a horizontal list with multiple values and converting it into a vertical list

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

Hello mcfurlong1 and Welcome to Excel Forum.
This proposal employs two helper columns (E:F) which may be moved and/or hidden for aesthetic purposes. It also assumes that you have Excel version 2010 or later, please update your profile to indicate the year version of excel or 365 for the subscription version as different versions support different functions (makes it easier to help).
Column E is populated using: =COUNT(B2:D2)
Column F is populated using: =SUM(E2,F1)
The output columns are populated using
Client Name: =IFERROR(INDEX(A$2:A$6,AGGREGATE(15,6,(ROW(A$2:A$6)-ROW(A$1))/(F$2:F$6>=ROWS(A$1:A1)),1)),"")
Client Numbers: =IF(H2="","",INDEX(B$2:D$6,MATCH(H2,A$2:A$6,0),COUNTIFS(H$2:H2,H2)))
For future reference, you will usually get faster results if you utilize the instructions in the banner at the top of the page.
Let us know if you have any questions.