I'd like to generate a URL based on a list of items that will change over time and I'm having a little trouble. My data looks like this:

Items URL
Item 1 Item1URL
Item 2 Item2URL
Item 3 Item3URL

and I'd like to generate a URL that looks like this: "website.com/?items&Item1URL&Item2URL&Item3URL"

Right now I have this formula, but it only returns "website.com/items?&Item1URL"

="https://www.website.com/items?"&query(A3:B,"SELECT B WHERE A <> ''")

Can anyone help?


1 Answer 1


Use textjoin(), like this:

="https://www.website.com/items?" & textjoin("&", true, B3:B)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.