Splitting numbers separated by a space automatically?

Good Morning,

Im after some help with the following if possible.

Currently i have a list of customer codes each seperated by a space. In the column next to them i have a percentage. (please see attached file before tab).

I would like to be able to split the cell of customer codes and transpose them so that there is one cell per customer code with the appropriate % applied (please see attached file after example tab).

At the minute a manual process is completed of sorting in length order, using the text to column function then copy paste and transpose, then copy the % in. Its quite manual process, is there an easier way?

Thanks

Barney