retrieve column name if empty

[ZeNable]

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    Col2  Col3  Col4        Wanted

A	B			Col3, Col4
	B			Col1, Col3, Col4
A		C		Col2, Col4
A				Col2, Col3, Col4
	B		D	Col1, Col3

[ZeNable]

Hi ryan_mayu,

Thanks for this exemple, it help me a lot, i have a last need, i need to get a specific empty column name ( Col1, Col2) not all of them, what is the fonction to add for that please ?

Regards,

ZeNab

[ZeNable]

Hi ryan_mayu,

Thanks for this exemple, it help me a lot, i have a last need, i need to get a specific empty column name not all of them, what is the fonction to add for that please ?

Regards,

ZeNab

[ryan_mayu]

what's the expected output based on the sample data you provided?

Could you pls update?

[ZeNable]

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]

sry, 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

[ZeNable]

Col1    Col2  Col3  Col4     Wanted

A	B			Col3
	B			Col1, Col3
A		C		Col2
A				Col2, Col3
	B		D	Col1, Col3

[ryan_mayu · Accepted solution]

pls see the attachment below

[ZeNable]

Thank you ryan_mayu 😉

[ryan_mayu]

@ZeNable 

here is a workaround for you, pls see the attachment below