Auto Populate Column Data


I have a sheet that I am populating row one with data inputted using an intake form (Form1). I then have a Update form (Form2) that is used by end users to input additional data.

I need the data inputted from form1 to auto populate the entire column the data resides in when form2 is submitted.

Any suggestions on how to accomplish this since I cannot apply cell formula to a column?

Best Answer