Thanks for this solution, it works very good. Unfortunately, i have a small issue here. In my matrix in the column A in some cases i have the same value (for eg. "ROWHEADER1") but with different information in the value range B1:F5. Do you have a solution also for this scenario?
Thanks
I wish you a nice day,
Alina