report in Excel

[Nitin231]

Dear All, Please help i have below report with me i want to combine some field

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>

please help your assitance will be highly appreciated.

 

[ranman256]

have you tried a pivot table?

 

[SpillerBD]

You will still need a additional table to help group the items as your example is setup.
For Example, the original date has an item "Tourism Dirham Fee" that needs a relationship to "Govt Fee"
For a small data set you can use VLOOKUP, but a better solution (and learning opportunity) is to link via the data model.

 

[Nitin231]

have you tried a pivot table?

Thank you for actually i tried and it worked!! Thank once again for an idea