Google sheet formula for append data in a column value

 =arrayformula("/or" & A1:A43 )

add the above formula to any cell

here /or will added to each cell value of the column starting from A1 to A43