CREATE TABLE array_test (
  text_column TEXT []
);

INSERT INTO array_test (text_column) VALUES (ARRAY ['test']), (ARRAY [NULL]), (ARRAY [NULL, 'test']);

UPDATE array_test
SET text_column = (SELECT array_agg(x)
                   FROM unnest(text_column) x
                   WHERE x IS NOT NULL);