I have a problem my be simple for some.

I have data in 10 colums, some of the data has empty colums between each other or before and after each other. I would like to shift all the data in the colums up against the one berfore it so the columns have no blanks at the start only after.

If this makes no sense. i will try to explain again.