How to get column name from table from 2 rows of same table having same value?

Id  BatchName      TblName           SubBatchName     Status
1   12032014    Tbl_12032014_raw2_1  raw2           Complete    
2   12032014    Tbl_12032014_raw2_2  raw2           Complete    
3   12182014    Tbl_12182014_raw3_1  raw3           Complete        
4   12182014    Tbl_12182014_raw3_2  raw3           InComplete      
5   12182014    Tbl_12182014_raw4_1  raw4           InComplete      
6   12182014    Tbl_12182014_raw4_2  raw4           InComplete      

i want output like below

BatchName                                          SubBatchname                                       
-------------------------------------------------- -----------
12032014                                           raw2_0     

If both tablename are having status complete then and then only SubBatchName Get select

Thanks