Heh heh, solutions above are for removing whitespace in column names.
If you post some sample data, and table structure, you are much more likely to get a useful solution.
See http://www.sqlservercentral.com/articles/Best+Practices/61537/ for how to post data in the way most likely to get a useful response!