Database

[{"_id":10001,"university":"SPYU","Courses":["English","French"],"dept":["Literature"],"type":["Autonomous"],"status":"ACTIVE","isMarked":true},{"_id":10002,"university":"SPYU","Courses":["English","French"],"dept":["Literature"],"type":["Autonomous"],"status":"NON-ACTIVE","isMarked":true}]

Query

db.collection.aggregate([{"$match":{"university":"SPYU"}},{$facet:{universities:[{"$addFields":{"isMarked":{"$in":["French","$Courses"]}}},{$unwind:"$dept"},{"$group":{"_id":"$dept","values":{"$push":"$$ROOT"}}}],findDistinct:[{$group:{_id:null,Courses:{$addToSet:"$Courses"},Status:{$addToSet:"$status"}}},{$project:{_id:0,dist:[{name:"Courses",values:{$reduce:{input:"$Courses",initialValue:[],in:{$setUnion:["$$this","$$value"]}}}},{name:"Status",values:"$Status"}]}},{$unwind:"$dist"},{$replaceRoot:{newRoot:"$dist"}}]}}])

Result