Thanks @Kristin and @David_Wong ,
I changed the data into the above format manually and I got the visual.
I tried to change the data with the Pivot table, but I didn’t get what I am expecting.
Would please refer me to any blog to change the data into the above format using an excel pivot table.