How to achieve this output

[surajseshan]

I have this input below

Input screen shot

i need the desired output

Output screen shot - 

Note :- Budgeted hours (new column) to be fixed at 250 hours for each month

Actual hours should be sum of charged hours on each month

Month - group by month and year in the same format as given in output screenshot

[FinnCharlton]

Hi @surajseshan , here's one way to match the output:

[ShankerV · Accepted solution]

Hi @surajseshan 

Please find the expected output..

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @surajseshan 

Explaining the steps in details to show how the solution will work dynamically.

Step 1: Input

Step 2: Formula tool to fetch the Month and Year alone.

As date is of no use, as we need the days by month and year.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @surajseshan 

Step 3: Summarize tool to consolidate (Groupby) month name and Sum all the hours

Step 4: Sort tool to sort the month in format May, June, July in the upcoming steps

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @surajseshan 

Step 5: Formula tool to modify the Month 05-22 to May-22 as expected in output

Then also inputting the Budgeted hours as 250.

Step 6: Record ID tool, 

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @surajseshan 

Step 7: Transpose tool to move from Row to column format

Step 8: Cross tab tool to realign the data

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @surajseshan 

Step 9: Sorting by Name

Step 10: Record ID tool

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @surajseshan 

Step 11: Sorting by Record ID to get the right format

Step 12: Select tool

Post run, expected result:

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @surajseshan 

As we have used the Summarize tool with Sum option, the changes in the input for the month of June gives the right output.

Output:

Many thanks

Shanker V