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.