Create a new column with content of a specific cell reference

I have a text in a column named Column1 at row 4, which I need to apply against each row of data as a new column.

I have tried as follows: = Table.AddColumn(#"PreviousStep", "NewColumn", each [Column1]{3}) 

I don't get any syntax error and the new column gets created, but every line in this new column just shows "Error"

Can you help solve this issue.