My work sheet looks like this:

4616 l STOKES l ST
2844 l OAKDALE l ST
2919 l KING COLE l DR
3504 l COLONIAL l AVE
3218 l SUNNYVALE l ST
2837 l OAKDALE l ST
3714 l SUNNYVALE l ST

I want to merge to be like this "4616 STOKES ST". Whats the easiest way to
do this?