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 [Colum...