Help in building SQL Server Query

Hi,

I need some help in creating the SQL Server query.

I will share the input data and sample output data and you need to build the query to match the required output.