Since you're new here, you should definitely read this article... it explains how to post questions to get the best help.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Once we have some sample data, answering your questions should be pretty easy.