Database
[{"_id":"63b285b9e92eee614feb7be1","status":"LUNCH","Date":"2023-01-02T00:00:00.000Z"},{"_id":"63b2db8db10c24487201e0a2","status":"DINNER","Date":"2023-01-02T00:00:00.000Z"},{"_id":"63b39b247adbeb50bfbe3503","status":"BREAK FAST","Date":"2023-01-03T00:00:00.000Z"},{"_id":"63b3d248c076184fb07ff2c4","status":"LUNCH","Date":"2023-01-03T00:00:00.000Z"},{"_id":"63b42b8ccb57a4cb7af34015","status":"DINNER","Date":"2023-01-03T00:00:00.000Z"},{"_id":"63b4ef71e038498fe6634506","status":"BREAK FAST","Date":"2023-01-04T00:00:00.000Z"}]
Query
db.collection.aggregate([{$group:{_id:"$Date",_idVal:{$first:"$_id"},data:{"$addToSet":"$status"}}},{$replaceRoot:{newRoot:{$mergeObjects:[{_id:"$_idVal",Date:"$_id"},{$arrayToObject:{$reduce:{input:"$data",initialValue:[],in:{$concatArrays:["$$value",[{k:{$concat:["status",{$toString:{$add:[{$size:"$$value"},1]}}]},v:"$$this"}]]}}}}]}}}])