Combining information for same date and then produce report

[kypok999]

Hi Guys,

I have data which I would like to automate for my reporting so

I have raw data so firstyl i would like to group by dates if ship name is the same and if "Secondary Mode" is Breakdown also I want to group by "Description" if its the same

So If Ship nm1 had breakdown in january from 01/01/2017 till 16/01/2017 if Secondary mode is "breakdown" I want report to show

01/01/2017-01/16/2016 Ship NM1 Breakdown and Description I attached file as example with data

https://docs.google.com/spreadsheets/d/1vLOpUxXs6v93Luf-iZOIwTVUmHCnwMuj0dmFkHMiUrM/edit?usp=sharing

thank you

 

[AFPathfinder]

I'm nearly positive this would have to be a VBA solution. It would have to check for concurrent dates, too, right? There is a gap between 1/13/2017 and 1/16/2017 is why I ask. What if the Main Mode value changes? Columns I & J would need to be summed? Is there an instance where the ship number and ship name are not matching?