Pivot of table

Hello Experts, i’m trying to achieve pivot source data. but not working as expected. Attaching source file and expected result. Source.xlsx (10.4 KB) Any help will be help ful. Regar...