Create New Table with row count

HELP!   I want to create a new table like I've created in an Excel. I've made a yellow table(right) from a pivot table(left).     I will appreciate your help!