Arrange Data

I have a file (working.xlsm) in which I need to move information from one place to another.

The data that needs to be moved can be found in Y2:AW1220

All data must stay in the row it originated in.

The numerical value preceding the string must be transfered to the column associated with the string. (ie. Y2 should be moved to V2)

I can manually go back and delete the originating information. So clean up is not an issue just the transfer of data.