Dear All, Please help i have below report with me i want to combine some field
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col><col><col span="7"></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>please help your assitance will be highly appreciated.
Below is the data available | ||||
Transaction Date | Transaction Description | Transaction Code | Net Amount | Name |
1/21/2018 | Charges 1 | 1000 | 718.34 | AB Wright |
1/21/2018 | Tax type 1 | 8300 | 71.83 | AB Wright |
1/21/2018 | Tax Type 2 | 8400 | 71.83 | AB Wright |
1/21/2018 | Vat Tax | 7500 | 39.51 | AB Wright |
1/21/2018 | Charges 2 | 2003 | 31.66 | AB Wright |
1/21/2018 | Govt Fee | 7525 | 15 | AB Wright |
1/21/2018 | Tax Type 3 | 8460 | 3.17 | AB Wright |
1/21/2018 | Tax type 4 | 8360 | 3.17 | AB Wright |
1/22/2018 | Charges 1 | 1000 | 718.34 | AB Wright |
1/22/2018 | Tax type 1 | 8300 | 71.83 | AB Wright |
1/22/2018 | Tax Type 2 | 8400 | 71.83 | AB Wright |
1/22/2018 | Vat Tax | 7500 | 39.51 | AB Wright |
1/22/2018 | Charges 2 | 2003 | 31.66 | AB Wright |
1/22/2018 | Tourism Dirham Fee | 7525 | 15 | AB Wright |
1/22/2018 | Tax Type 3 | 8460 | 3.17 | AB Wright |
1/22/2018 | Tax type 4 | 8360 | 3.17 | AB Wright |
1/21/2018 | Charges 1 | 1000 | 718.34 | Mr. Bean |
1/21/2018 | Tax type 1 | 8300 | 71.83 | Mr. Bean |
1/21/2018 | Tax Type 2 | 8400 | 71.83 | Mr. Bean |
1/21/2018 | Vat Tax | 7500 | 39.51 | Mr. Bean |
1/21/2018 | Charges 2 | 2003 | 31.66 | Mr. Bean |
1/21/2018 | Govt Fee | 7525 | 15 | Mr. Bean |
1/21/2018 | Tax Type 3 | 8460 | 3.17 | Mr. Bean |
1/21/2018 | Tax type 4 | 8360 | 3.17 | Mr. Bean |
1/22/2018 | Charges 1 | 1000 | 718.34 | Mr. Bean |
1/22/2018 | Tax type 1 | 8300 | 71.83 | Mr. Bean |
1/22/2018 | Tax Type 2 | 8400 | 71.83 | Mr. Bean |
1/22/2018 | Vat Tax | 7500 | 39.51 | Mr. Bean |
1/22/2018 | Charges 2 | 2003 | 31.66 | Mr. Bean |
1/22/2018 | Tourism Dirham Fee | 7525 | 15 | Mr. Bean |
1/22/2018 | Tax Type 3 | 8460 | 3.17 | Mr. Bean |
1/22/2018 | Tax type 4 | 8360 | 3.17 | Mr. Bean |
Above is the Available Data |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Below is the report how I want to define. Every time the upper values changed or the text same should be changed in the below report. The below report should come in the next work sheet. | ||
Above Data Range can be longer, so I want to define the below report as per the above range it its longer the below report should be longer as well. |
<colgroup><col><col><col><col><col><col span="7"></colgroup><tbody>
</tbody>
Required Report | |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Required Report | |||
Date | Description | Amount | |
AB Wright | |||
21/1/2018 | Charges 1 (Charges1+Charges 2) | 750 | |
21/1/2018 | Tax type 1 (Tax type 1 + Tax type3) | 75 | |
21/1/2018 | Tax Type 2 (Tax type 2 + Tax type4) | 75 | |
21/1/2018 | Vat Tax | 39.51 | |
21/1/2018 | Govt Fee | 15 | |
21/1/2018 | Charges 1 (Charges1+Charges 2) | 750 | |
21/1/2018 | Tax type 1 (Tax type 1 + Tax type3) | 75 | |
21/1/2018 | Tax Type 2 (Tax type 2 + Tax type4) | 75 | |
21/1/2018 | Vat Tax | 39.51 | |
21/1/2018 | Govt Fee | 15 | |
Subtotal | 1909.02 | ||
Mr. Bean | |||
21/1/2018 | Charges 1 (Charges1+Charges 2) | 750 | |
21/1/2018 | Tax type 1 (Tax type 1 + Tax type3) | 75 | |
21/1/2018 | Tax Type 2 (Tax type 2 + Tax type4) | 75 | |
21/1/2018 | Vat Tax | 39.51 | |
21/1/2018 | Govt Fee | 15 | |
21/1/2018 | Charges 1 (Charges1+Charges 2) | 750 | |
21/1/2018 | Tax type 1 (Tax type 1 + Tax type3) | 75 | |
21/1/2018 | Tax Type 2 (Tax type 2 + Tax type4) | 75 | |
21/1/2018 | Vat Tax | 39.51 | |
21/1/2018 | Govt Fee | 15 | |
Subtotal | 1909.02 | ||
Total | 3818.04 | ||
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>