Convert single row data with multiple columns into multiple-row data with only two columns

[basin_street]

I have a sheet with a list of song codes in the leftmost column, each row contains a unique song code. For each row there are 10 columns with names of songwriters/composers that correspond to each song code. The number of names per row varies; some rows have only 1 name, some have up to 10. I need the writer/composer names to all be in one column, with the same corresponding song codes. The rows with only one writer will remain unchanged. The rows with multiple writers will need to be duplicated so the song code appears the same number of times as there are writers of the song. ie. a song with three writers will have its song code repeated three times, each on a separate row, and with the three different songwriters on each row, as opposed to having them all in one row with the code only listed once.

Please see the attached sheet, as it will make what I am trying to accomplish much clearer. I have attached a sheet with two tabs—the first tab is the data as I currently have it, the second tab shows my desired result. In actuality I have many more lines to go through, so doing this manually is not an option. Any help with how to do this will be greatly appreciated.