motherindia
Board Regular
- Joined
- Oct 15, 2015
- Messages
- 218
Hello Sir
I have data on sheet1 as follows;
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
Output needed as below;
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
I have data on sheet1 as follows;
Cust ID | Type | Begin Date | End Date | No of days |
1 | Luxury | 23-Mar-17 | 23-Mar-17 | 1 |
1 | Luxury | 28-Mar-17 | 28-Mar-17 | 1 |
1 | Luxury | 29-Mar-17 | 29-Mar-17 | 1 |
1 | Luxury | 30-Mar-17 | 30-Mar-17 | 0.5 |
1 | Luxury | 31-Mar-17 | 31-Mar-17 | 0.5 |
1 | Luxury | 08-Apr-17 | 08-Apr-17 | 0.5 |
1 | Luxury | 08-Apr-17 | 08-Apr-17 | 0.5 |
1 | Luxury | 10-Apr-17 | 12-Apr-17 | 3 |
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
Output needed as below;
Cust ID | Type | Month-Year | Day | Total Days |
1 | Luxury | Mar-17 | 23,28,29,30,31 | 4 |
1 | Luxury | Apr-17 | 8,10,11,12 | 4 |
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
Regards, motherindia |
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>