Forum Discussion
retrieve column name if empty
Hi there, I have some difficulties to combine text columns name with the result I want. If someone could help me to point me to the right direction please 🙂 So I have this table : Col1 C...
pls see the attachment below
based on the example, I need to check a specific empty column name ( Col1, Col2,Col3) not all of the empty column.
Thanks alot
ryan_mayu
Super User
Super Usersry, still not understand your request. could you pls update the table below?
Col1 Col2 Col3 Col4 Wanted
| A | B | Col3, Col4 | ||
| B | Col1, Col3, Col4 | |||
| A | C | Col2, Col4 | ||
| A | Col2, Col3, Col4 | |||
| B | D | Col1, Col3 |
Col1 Col2 Col3 Col4 Wanted
A B Col3 B Col1, Col3 A C Col2 A Col2, Col3 B D Col1, Col3 - ryan_mayu
pls see the attachment below
Thank you ryan_mayu 😉