do not repeat again datas

I want following result how is use query
project ename
crm raja
ramu
tata
ERP arun
priya
vel
here project column is not return again and again project name coming in front page using dot net.
Is it possible in sqlserver query.
Thanks

i am not clear with your question .can you please write it more clearly

I want following result how is use query
project name
CRM raja
null ramu
null tata
ERP arun
null vel

CRM is poject this is working more member here i wrote that name
again and again did not enter project name, break on using in oracle
how using sqlserver