With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Sunday, March 18, 2018
yogi_Pull Row By Row Entries In Columns A:K into Column L
question by: Anonymous Gecko https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!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.