Pivot Table Format

Hi everyone,

I am new to this forum and as a beginner I need some help.
What I want to achieve is below,

Target_pivot table.png

Can anyone help me how to set? Move to Row or Move to column is not enough.

is it useful to you?


Regards
mahaveer somani

Thank you so much mahaveer for your interest.
It can't be done by just setting Pivot table options?

I am not that good in programming, as of now it is hard for me to modify the code to
achieve my target. I am still learning in excel macro.

Works great. The link wa very helpful.
Thank you so much.