[{"Id":"Q1D3","INT_ID":"1234","Location":"ENG","Company":"COMP1","start":20191001,"end":20230930},{"Id":"Q1D3","INT_ID":"1235","Location":"ENG","Company":"COMP1","start":20191001,"end":20230930},{"Id":"Q1D3","INT_ID":"1236","Location":"USA","Company":"COMP3","start":20191001,"end":20230930},{"Id":"Q1D3","INT_ID":"1237","Location":"USA","Company":"COMP3","start":20191001,"end":20230930},{"Id":"Q1D5","INT_ID":"1237","Location":"ENG","Company":"COMP1","start":20191001,"end":20230930},{"Id":"Q1D5","INT_ID":"1239","Location":"ENG","Company":"COMP1","start":20191001,"end":20230930},{"Id":"Q1D3","INT_ID":"1237","Location":"CAN","Company":"COMP1","start":20191001,"end":20230930}]

db.collection.aggregate([{$match:{Id:"Q1D3"}},{$group:{_id:{Location:"$Location",Company:"$Company",start:"$start",end:"$end"},doc:{$push:"$$ROOT"}}},{$unwind:"$doc"},{$group:{_id:"$doc.INT_ID",doc:{$first:"$doc"}}},{$replaceRoot:{newRoot:"$doc"}}])