[{"record":[{"cellguid":"N118M2J4","value":"Drinks"},{"cellguid":"V671H8W7","value":"Coca Cola"},{"cellguid":"savour","value":"light"}]},{"record":[{"cellguid":"N118M2J4","value":"Fruits"},{"cellguid":"V671H8W7","value":"Mango"},{"cellguid":"color","value":"yellow"}]},{"record":[{"cellguid":"N118M2J4","value":"Drinks"},{"cellguid":"V671H8W7","value":"Coca Cola"},{"cellguid":"savour","value":"lemon"}]},{"record":[{"cellguid":"N118M2J4","value":"Drinks"},{"cellguid":"V671H8W7","value":"Coca Cola"},{"cellguid":"savour","value":"light"}]},{"record":[{"cellguid":"N118M2J4","value":"Fruits"},{"cellguid":"V671H8W7","value":"Orange"},{"cellguid":"color","value":"orange"}]},{"record":[{"cellguid":"N118M2J4","value":"Drinks"},{"cellguid":"V671H8W7","value":"Pepsi"},{"cellguid":"savour","value":"light"}]},{"record":[{"cellguid":"N118M2J4","value":"Drinks"},{"cellguid":"V671H8W7","value":"Pepsi"},{"cellguid":"savour","value":"MAX"}]},{"record":[{"cellguid":"N118M2J4","value":"Drinks"},{"cellguid":"V671H8W7","value":"Pepsi"},{"cellguid":"savour","value":"crystal"}]},{"record":[{"cellguid":"N118M2J4","value":"Fruits"},{"cellguid":"V671H8W7","value":"Plum"},{"cellguid":"color","value":"yellow"}]},{"record":[{"cellguid":"N118M2J4","value":"Fruits"},{"cellguid":"V671H8W7","value":"Apple"},{"cellguid":"color","value":"golden"}]},{"record":[{"cellguid":"N118M2J4","value":"Drinks"},{"cellguid":"V671H8W7","value":"Water"},{"cellguid":"savour","value":"beer"}]},{"record":[{"cellguid":"N118M2J4","value":"Drinks"},{"cellguid":"V671H8W7","value":"Water"},{"cellguid":"savour","value":"ale"}]},{"record":[{"cellguid":"N118M2J4","value":"Drinks"},{"cellguid":"V671H8W7","value":"Water"},{"cellguid":"savour","value":"ale"}]},{"record":[{"cellguid":"N118M2J4","value":"Fruits"},{"cellguid":"V671H8W7","value":"Mango"},{"cellguid":"color","value":"yellow"}]}]

db.collection.aggregate([{"$group":{"_id":{"$reduce":{"input":{"$slice":["$record",0,3]},"initialValue":"","in":{"$concat":["$$value","$$this.cellguid","$$this.value"]}}},"datum":{"$first":{"$last":"$record"}},"n":{"$sum":1},"doc":{"$first":"$$ROOT"}}},{"$group":{"_id":{"$reduce":{"input":{"$slice":["$doc.record",0,2]},"initialValue":"","in":{"$concat":["$$value","$$this.cellguid","$$this.value"]}}},"datum":{"$first":{"$arrayElemAt":["$doc.record",1]}},"n":{"$sum":"$n"},"records":{"$push":{"cellguid":"$datum.cellguid","value":"$datum.value","records":"$records","n":"$n"}},"doc":{"$first":"$doc"}}},{"$group":{"_id":{"$reduce":{"input":{"$slice":["$doc.record",0,1]},"initialValue":"","in":{"$concat":["$$value","$$this.cellguid","$$this.value"]}}},"datum":{"$first":{"$arrayElemAt":["$doc.record",0]}},"n":{"$sum":"$n"},"records":{"$push":{"cellguid":"$datum.cellguid","value":"$datum.value","records":"$records","n":"$n"}},"doc":{"$first":"$doc"}}},{"$project":{"cellguid":"$datum.cellguid","value":"$datum.value","records":1,"n":1}}])