Macro to move data horizontal in one line

[JohnGreen2]

I have data in column B that run down I want to the data to look like column C. You will notice column B the value run down....I need it to look like the data in Column C

Rep given for someone that can assist with a macro to do the whole column B's data to column C.also in Column C if the spaces can be deleted as it should look like


145
125
149 ......no spaces in column C

Thanks for any help