Need some guidance on a challenge

[walktall777]

Dear Forum,

I need some help as I have no idea how to tackle this challenge.

I have data in the following format (about 7000 records):
[TABLE="width: 1044"]
<tbody>[TR]
[TD="width: 272"]User[/TD]
[TD="width: 300"]Project Code[/TD]
[TD="width: 124"]Transaction Date[/TD]
[TD="width: 64"]Hours[/TD]
[TD="width: 82"]Allocation[/TD]
[TD="width: 202"]Category[/TD]
[/TR]
</tbody>[/TABLE]

and need to do some calculations on it, and present it in this format:

User[TABLE="width: 202"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]Days in Month[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Billable (have info)[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Training (have info)[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Presales (have info)[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Leave (have info)[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Bench (have info)[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Rate (have)[/TD]
[TD="align: right"]425[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Monthly Cost (have)[/TD]
[TD="align: right"]5,446[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Earnings (calculation)[/TD]
[TD="align: right"]8,919[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Profit (calculation)[/TD]
[TD="align: right"]3,473[/TD]
[/TR]
</tbody>[/TABLE]

Any assistance would be greatly appreciated.

Kind regards,
walktall.

 

[James006]

Hello,

First of all ... Insert a Pivot Table ...

Hope this will help