Tax Report Category Wise

[khanzgem]

Hello - I need help form excel experts
I want to prepare a report in the following format.

If I need Employees Report CPR Wise, it should be like this
Month - CPR No - Payment Date - Amount
jul - 01-07-17 - 31-07-17 - 300
Aug - 01-08-17 -31-08-17 -300
Sep - 01-09-17 -30-09-17 - 300



Month - CPR No. - Payment Date - Amount - Tax Category - Tax Payer Name
Jul - 01-07-17- 31-07-17 - 100 - Employee Tax - Ahmad
Jul - 01-07-17- 31-07-17 - 100 - Employee Tax - Muhamamd
Jul - 01-07-17- 31-07-17 - 100 - Employee Tax - Khan
Jul - 02-07-17- 31-07-17 - 100 - Supplier Tax - ABC
Jul - 02-07-17- 31-07-17 - 100 - Supplier Tax - Nestle
Jul - 02-07-17- 31-07-17 - 100 - Supplier Tax - TCS
Jul - 03-07-17- 31-07-17 - 100 - Educational Tax - John
Jul - 03-07-17- 31-07-17 - 100 - Educational Tax - Ali
Jul - 03-07-17- 31-07-17 - 100 - Educational Tax - Kumar

Aug - 01-08-17- 31-08-17 - 100 - Employee Tax - Ahmad
Aug - 01-08-17- 31-08-17 - 100 - Employee Tax - Muhamamd
Aug - 01-08-17- 31-08-17 - 100 - Employee Tax - Khan
Aug - 02-08-17- 31-08-17 - 100 - Supplier Tax - ABC
Aug - 02-08-17- 31-08-17 - 100 - Supplier Tax - Nestle
Aug - 02-08-17- 31-08-17 - 100 - Supplier Tax - TCS
Aug - 03-08-17- 31-08-17 - 100 - Educational Tax - John
Aug - 03-08-17- 31-08-17 - 100 - Educational Tax - Ali
Aug - 03-08-17- 31-08-17 - 100 - Educational Tax - Kumar

Sep - 01-09-17- 30-09-17 - 100 - Employee Tax - Ahmad
Sep - 01-09-17- 30-09-17 - 100 - Employee Tax - Muhammad
Sep - 01-09-17- 30-09-17 - 100 - Employee Tax - Khan
Sep - 02-09-17- 30-09-17 - 100 - Supplier Tax - ABC
Sep - 02-09-17- 30-09-17 - 100 - Supplier Tax - Nestle
Sep - 02-09-17- 30-09-17 - 100 - Supplier Tax - TCS
Sep - 03-09-17- 30-09-17 - 100 - Educational Tax - John
Sep - 03-09-17- 30-09-17 - 100 - Educational Tax - Ali
Sep - 03-09-17- 30-09-17 - 100 - Educational Tax - Kumar

Thanking you in anticipation
Saeed Khan