I am looking for a way to automatically transpose data from columns to rows based on merged cells. I have attached an example of how I imagine the result should look like.

I tried adding this data to Pivot table but it didn’t help. The data will not be converted to the form I need.

Thank you for answer.