I am trying to find a function where I can return Row and Column Headers of a data from a table. I have attached a screenshot of a sample data table.

enter image description here

And below is the result I am working out.

enter image description here

Here’s a link of the sample sheet. https://docs.google.com/spreadsheets/d/1KzS0HaHzPiUVeAOVRV53ifLZ5Nhg1t733ySWKSEIgI0/edit?usp=sharing

Any assistance is greatly apreciated.

Thank you

I tried researching the internet and here as well. I have encountered index-query formula, but I haven’t really understand it well. I have tried the common lookup functions.