Sunday, March 18, 2018

yogi_Pull Row By Row Entries In Columns A:K into Column L

Google Spreadsheet   Post  #2399

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Mar-18-2018

question by: Anonymous Gecko!topic/docs/kVU2ynMJRGA;context-place=forum/docs
How to duplicate a word in a cell located in a whole row of empty cells?

As the title says,

I have a whole row ( Ex. A1 to A10 ) of empty cells. Say there is a Data is cell A5, then A11 has to replicate the word located in the row range (A1 - A10).

The Data can be randomly generated anywhere from A1-A10 (using google form), so the output has to be replicated in A11.

Also the same has to generated below to new responses as well using Array formula.

Please help me with this equation.