How to display Data as per screen shot

Hi ,

I need to display below format data to

I tried using Pivot table But did not work.