Merging repeated groups to main sheet?

Welcome to the community, @mohamed_bashier! Thank you also for updating the post and letting the community know about Vlookup. We also have a support article that should merge the data through power query (which should be much easier):