How to return Row and Column header of a data in table
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.
And below is the result I am working out.
Here's a link of the sample sheet.
https://docs.google.com/spreadsheets/d/1KTBM0T05MJtPFGUw_UoxWheksXv7vDKbCvzlZr7V_Yk/edit?usp=sharing
Any assistance is greatly appreciated.
Thank you
I tried researching the internet and here as well. I have encountered index-query formula, but I haven't really been understanding it well. I have tried the common lookup functions.
Solution
try:
=INDEX(SPLIT(TOCOL(B3:F7&"×"&A3:A7&"×"&B1:F1&"×"&B2:F2), "×"))
with open ranges:
=INDEX(SPLIT(TOCOL(FILTER(B3:F, A3:A<>"")&"×"&TOCOL(A3:A, 1)&"×"&B1:F1&"×"&B2:F2), "×"))
- How to combine multiple conditions in a PowerShell if-statement
- I get an error when I end the if statement with a concluding else statement
- Does PHP have short-circuit evaluation?
- Why is this code still adding 1 to i even when the if statment that does so isnt called in C?
- error compiling in c user input
- R Conditional IfElse With Random Values
- Can not get past illogical line pep8 error
- smarty help with if statement
- 'if' must have both main and 'else' branches if used as an expression
- What is the standard for choosing "when" vs "if/else" in Kotlin?
- Python script continuously repeats the first if - else statement
- Why does python use 'else' after for and while loops?
- Use of ternary operator instead of if-else in C++
- Evaluate boolean environment variable in Python
- How to use if/else statement in terraform for loop
- change number grade to letter grade
- How to debug this substring matching code?
- If condition is getting skipped even if the condition is true
- Assign value to all rows based on condition being fulfilled or not
- Looping through a list in Python
- Why does if (fork() || fork() || fork()) behave differently?
- Python if not == vs if !=
- Discord.py | If statement not working correctly
- Angular 17 - In @if syntax, how to store returned value from a function in a variable and use it in the same @if block
- Angular: ng-content doesn't render with *ngIf then else
- How to get the next Bi-weekly date based on a given start date and today's date in Google Sheets
- What is the best way to refactor an if else branch
- Unreachable code in if-else structure
- Python if/else/elif
- Ternary conditional operator in Scala