Return Column Header if Value is "1"

[YLYONG]

Hello!

Need help in identifying a smarter way to return the column header if the value is "1"

Parent TU ID	Has_AIO	Has_COM	Has_CPS	Has_DG1	Has_MO1	Consolidation Type
202464640	1	0	0	1	0	AIO -> DG1
202358880	1	1	0	0	0	AIO -> COM
202634920	1	0	0	1	1	AIO -> DG1 -> MO1
202611840	1	1	0	0	0	AIO -> COM
202641300	1	0	1	0	0	AIO -> CPS

Thank you for your help once again!

[grazitti_sapna · Accepted solution]

Hi @YLYONG , give this a try.

Thanks!

[binuacs]

@YLYONG one way of dong this

[flying008]

Hi, @YLYONG 

Try this way if you like: