I need a google sheets expert
Budget: $10 – $30 USD
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
=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