[{"_id":ObjectId("60ce12bafafd606599a4110f"),"id":"id1","user":"user1","study":"study","form":"f1","formData":[{"e11":"value1"},{"e12":"value2"},{"e13":"value3"}]},{"_id":ObjectId("60ce12bafafd606599a41110"),"id":"id2","user":"user1","study":"study","form":"f1","formData":[{"e11":"value4"},{"e12":"value5"},{"e13":"value6"}]},{"_id":ObjectId("60ce12bafafd606599a41111"),"id":"id3","user":"user1","study":"study","form":"f2","formData":[{"e21":"value7"},{"e22":"value8"}]},{"_id":ObjectId("60ce12bafafd606599a41112"),"id":"id4","user":"user1","study":"study1","form":"f2","formData":[{"e21":"value9"},{"e22":"value10"}]},{"_id":ObjectId("60ce12bafafd606599a41113"),"id":"id2","user":"user2","study":"study1","form":"f2","formData":[{"e21":"value11"},{"e22":"value12"}]}]

db.collection.aggregate([{$group:{_id:{"user":"$user","form":"$form",},"formData":{"$push":{"$concatArrays":["$formData",[{"study":"$study"}]]},},}},{$group:{_id:{"user":"$_id.user",},formData:{"$push":"$formData"}}},{$project:{"formData":{"$map":{"input":{"$arrayElemAt":["$formData",0]},"as":"f1","in":{"$cond":{"if":{"$gt":[{"$size":"$formData"},1]},"then":{"$map":{"input":{"$arrayElemAt":["$formData",1]},"as":"f2","in":{"$concatArrays":["$$f1","$$f2"],},},},"else":["$$f1"]},},},},}},{$unwind:{path:"$formData",}},{$unwind:{path:"$formData",}},{$replaceRoot:{newRoot:{"$mergeObjects":[{"user":"$_id.user"},{"$reduce":{"input":"$formData","initialValue":{},"in":{"$mergeObjects":["$$this","$$value"],}},},],}}}])