
Google Sheets- Copy Paste Loop, Ignore Blanks, Add Random Number
- or -
Post a project like this1735
£15(approx. $20)
- Posted:
- Proposals: 3
- Remote
- #3211227
- Awarded
Description
Experience Level: Entry
Hi there - please read description first. This is a very quick task and won't take long.
I need a google script created for use on google sheets. The script should loop through every cell in a range (ignoring blank cells) then copy the non blank cells plus a 5 digit random number to another column. See attached image example (copies A1:A7 to C1:C7). The script need to run efficiently as will be used on much bigger data sample. Each time the script is run a new random number should be generated.
Thanks
I need a google script created for use on google sheets. The script should loop through every cell in a range (ignoring blank cells) then copy the non blank cells plus a 5 digit random number to another column. See attached image example (copies A1:A7 to C1:C7). The script need to run efficiently as will be used on much bigger data sample. Each time the script is run a new random number should be generated.
Thanks
Steven H.
100% (71)Projects Completed
17
Freelancers worked with
16
Projects awarded
84%
Last project
9 May 2025
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies