Forum Discussion
Solved
Looking for help on a code
Hello, how are you doing I hope everything is fine, I need some help regarding a code I want to write, I have a product dataset and it's structured in a strange way to be specific it's structured as...
In F2:
=INDEX(Table2[[#Headers],[Product 1]:[Product 9]],MATCH(9.99999999999999E+307,Table2[@[Product 1]:[Product 9]]))
Alternatively, to return all products in a single cell:
=TEXTJOIN(", ",TRUE,FILTER(Table2[[#Headers],[Product 1]:[Product 9]],Table2[@[Product 1]:[Product 9]]<>""))
In F2:
=INDEX(Table2[[#Headers],[Product 1]:[Product 9]],MATCH(9.99999999999999E+307,Table2[@[Product 1]:[Product 9]]))
Alternatively, to return all products in a single cell:
=TEXTJOIN(", ",TRUE,FILTER(Table2[[#Headers],[Product 1]:[Product 9]],Table2[@[Product 1]:[Product 9]]<>""))
- Wow Hans as usual thank you so much for your support I really appreciate it
