Database
[{"_id":ObjectId("609ce6275a23f5353438183d"),"name":"name11","value":"name11","type":"test1","active_ind":true},{"_id":ObjectId("609ce6a35a23f5353438183e"),"name":"name12","value":"name12","type":"test1","active_ind":true},{"_id":ObjectId("609ce6c65a23f5353438183f"),"name":"name21","value":"name21","type":"test2","active_ind":true},{"_id":ObjectId("609ce7305a23f53534381840"),"name":"name22","value":"name22","type":"test2","active_ind":true},{"_id":ObjectId("609ce7b55a23f53534381841"),"name":"name31","value":"name31","type":"test3","active_ind":true},{"_id":ObjectId("609ce8185a23f53534381842"),"name":"name32","value":"name32","type":"test3","active_ind":true},{"_id":ObjectId("609ce83e5a23f53534381843"),"name":"name41","value":"name41","type":"test4","active_ind":true},{"_id":ObjectId("609ce8805a23f53534381844"),"name":"name42","value":"name42","type":"test4","active_ind":true},{"_id":ObjectId("609ce8915a23f53534381845"),"name":"name51","value":"name51","type":"test5","active_ind":true},{"_id":ObjectId("609ce8a15a23f53534381846"),"name":"name52","value":"name52","type":"test5","active_ind":true},{"_id":ObjectId("609ce8be5a23f53534381847"),"name":"name61","value":"name61","type":"test6","active_ind":true},{"_id":ObjectId("609ce8f25a23f53534381848"),"name":"name62","value":"name62","type":"test6","active_ind":true},{"_id":ObjectId("609ce9025a23f53534381849"),"name":"name71","value":"name71","type":"test7","active_ind":true},{"_id":ObjectId("609ce9025a23f53534381850"),"name":"name72","value":"name72","type":"test7","active_ind":true}]
Query
db.collection.aggregate({$match:{type:{$in:["test1","test2","test3","test4","test5"]}}},{$project:{_id:0,name:1,value:1,type:1}},{$group:{_id:"$type",variable:{$push:{name:"$name",value:"$value",type:"$type"}}}})