[{"_id":ObjectId("62bab00ea4b4ebd48908457d"),"id":"xxx1234","masterVariant":{"attributes":[{"name":"propertyA","value":"CJS"},{"name":"propertyB","value":300},{"name":"propertyC","value":221},{"name":"propertyE","value":"dasdags"}]}},{"_id":ObjectId("62bab00ea4b4ebd48908457e"),"id":"xxx1235","masterVariant":{"attributes":[{"name":"propertyB","value":"CJS"},{"name":"propertyA","value":300},{"name":"propertyE","value":221},{"name":"propertyX","value":"dasdags"}]}}]

db.collection.aggregate([{"$unwind":"$masterVariant.attributes"},{"$project":{"id":"$id","propertyA":{"$cond":[{"$eq":["$masterVariant.attributes.name","propertyA"]},"$masterVariant.attributes.value",null]},"propertyE":{"$cond":[{"$eq":["$masterVariant.attributes.name","propertyE"]},"$masterVariant.attributes.value",null]},}},{"$group":{"_id":"$_id","id":{"$first":"$id"},"propertyA":{"$push":{"$cond":[{"$ne":["$propertyA",null]},"$propertyA","$$REMOVE"]}},"propertyE":{"$push":{"$cond":[{"$ne":["$propertyE",null]},"$propertyE","$$REMOVE"]}},}},{"$project":{"id":"$id","propertyA":{"$first":"$propertyA"},"propertyE":{"$first":"$propertyE"},}}])