Change table value

Hi

I am using a table dashboard to display status of doors/windows but the value returned is either on or off, is there any way I can set my table to change to value displayed from “on” to “open” and “off” to “closed”

I have looked at transform but this doesn’t seem to work nor does value mappings.

Thanks