Numbers V3: If cell contains a value, convert cell value to X
Here are a few hints:


use an auxiliary column;
use functions ISBLANK and IF;
replicate the auxiliary column within the original one;
remove the auxiliary column.