I am finding your question difficult to follow. Can you take a look at the first link in my signature and then provide your consumable sample data, with DDL and desired results please?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.