question.PNG

Hello everyone,

I have data as shown in attached image.
My input data is as shown in first column, i need in command in 2nd column such that it removes blank spaces and give me values as shown in column 2.

Thanks