I've got a Google Sheet with columns along the lines of:

URL | Pageviews | Time on Page

The same URL is sometimes on multiple rows and I'd like to merge the two other columns together so that the data is aggregate for each.

Is there any easy way to achieve this?

  • Do you want to merge all the data per URL or for the last two columns?
    – Julio
    Commented Jan 29, 2014 at 2:02

1 Answer 1


In a new adjacent column, let's call it Merged, add the JOIN formula. Below is an example with =JOIN(" and ", B2, C2). Then drag to duplicate the formula in the rest of the column. In your case you might use a comma ", " instead. But that's the gist of it.

enter image description here

More info on the formula here.

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.