Example The requirement is as below to get the alerts data of each date and add a row before each date as Monitoring. please find the attached my excel sheets
Currently it is adding before all the alerts as below
Can any one please help me with the necessary correction
01-Feb-2020 | Monitoring | Nagios | Remedy | |
01-Feb-2020 | Alert | L2 | AlertName1 | AlertDescription1 |
01-Feb-2020 | Alert | L2 | AlertName2 | AlertDescription2 |
02-Feb-2020 | Monitoring | Nagios | Remedy | |
02-Feb-2020 | Alert | L2 | AlertName5 | AlertDescription5 |
02-Feb-2020 | Alert | L2 | AlertName6 | AlertDescription6 |
02-Feb-2020 | Alert | L2 | AlertName6 | AlertDescription6 |
Currently it is adding before all the alerts as below
01-Feb-2020 | Alert | L2 | AlertName1 | AlertDescription1 |
01-Feb-2020 | Monitoring | Nagios | Remedy | |
01-Feb-2020 | Alert | L2 | AlertName2 | AlertDescription2 |
01-Feb-2020 | Monitoring | Nagios | Remedy | |
02-Feb-2020 | Alert | L2 | AlertName5 | AlertDescription5 |
02-Feb-2020 | Monitoring | Nagios | Remedy | |
02-Feb-2020 | Alert | L2 | AlertName6 | AlertDescription6 |
Can any one please help me with the necessary correction