Closed

I need a google sheets expert

just need some help figuring out how to make a formula do what i need it to, the formula that i need takes one page in the sheet and moves over all of the values within a specific range on that sheet to a list on another sheet, the problem i am having is that the formula looks like this

=textjoin(char(10),true,LOADS!A2:A14)

but when i pull it down to copy the value it turns into this

=textjoin(char(10),true,LOADS!A3:A15)

what i need is to know how to make the next formula start at where the last formula ended

Skills: Excel, Data Entry, Data Processing, Google Sheets

About the Client:
( 0 reviews ) Bainbridge, United States

Project ID: #34331610

57 freelancers are bidding on average $19 for this job

(1059 Reviews)
8.3
(521 Reviews)
8.4
(549 Reviews)
7.9
daniyal3214

Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power More

$20 USD in 1 day
(183 Reviews)
7.1
(123 Reviews)
6.5
(100 Reviews)
6.3
SShtv

Hello! I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Google Sheets, including using formul More

$30 USD in 1 day
(121 Reviews)
6.5
renesontiongson

Pleasure to help you. Google spreadsheet automation is my masterpiece in my accounting field. Feel free to message me for more details. Thanks.

$30 USD in 1 day
(76 Reviews)
5.7
hamidr2020

Hello, I am an Excel / Google Sheets expert. I can help to make the next formula start at where the last formula ended. We can discuss further details over chat. You can check my reviews for quality of work and client More

$20 USD in 1 day
(63 Reviews)
5.5
sobhad20

Hi There, I can do this right now with perfectly. Please message me to start your work now. Regard's Sobha

$10 USD in 1 day
(116 Reviews)
5.3
merinsinha

Google sheets expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipa More

$25 USD in 1 day
(151 Reviews)
5.6
vishal54sharma

VERY EASY!!! just need to modify the formula to be used with the combination or rows and columns. I can help you in framing a formula to start from where the last cell was ending (the range). I am a google sheet exp More

$15 USD in 1 day
(60 Reviews)
4.7
aruls1962

I’m a professional Engineer who has spent the past 7 years building, developing, and perfecting systems (from the ground up) through Google Sheets. With over 30 years of experience in the industry, I’ve not only learne More

$20 USD in 7 days
(19 Reviews)
4.2
(12 Reviews)
4.2
Baskoro885

Hi, can you chat me please. I know how it should be. I tell you how to do it. Thank you and regards.

$10 USD in 1 day
(2 Reviews)
1.1
caphoenk

I am interested in this job, and I will finish it soon I will be happy if my offer can be accepted I will do it carefully according to your wishes

$15 USD in 10 days
(0 Reviews)
0.0
cranpalacios

Hello I would love to help you with your problem. I have advanced experience in spreadsheets I await your contact!

$20 USD in 1 day
(0 Reviews)
0.0
SHAFMIKHAIL

I have 5 years of experience in data entry and project management. I am also commissioned as a trainer for Microsoft Excel and Power Point. thank you

$20 USD in 7 days
(0 Reviews)
0.0
maheshkarla88

_________________________"YOUR SATISFACTION IS MY ASSET"_________________________ Hello Client, I understand you're looking for someone to do data entry, and I have a lot of experience of more than 3 years in the field More

$20 USD in 7 days
(0 Reviews)
0.0
amirsohel696

Hello, I saw your job all job Description. I can start this project right now with 100% accuracy. I work efficiently and will finish in a timely manner and will provide high quality work. I am waiting to your quick pos More

$20 USD in 5 days
(0 Reviews)
0.0