Google-sheets – How to merge multiple rows in Google Docs

google sheets

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?

Best Answer

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.

Related Solutions

Google Sheets – Adding Formulas to Google Forms Responses

If you add the following formula in cell D2:

=ARRAYFORMULA(FILTER(C2:C;C2:C<>"")*1.2)

then it will take on the complete column, via the array. The FILTER function, is to make sure no empty cells are taken into account.

I've added the result into the file you shared with us.

Google-sheets – Case insensitive character string filter for multiple individual columns (dynamic input for each)

It appears that you are using regexmatch just to test string equality. This isn't necessary, equalities can be entered simply as Data!A:A = A1. You don't even need lower, because string comparison in filter is case-insensitive:

=filter(Data!A:R, Data!A:A = A1, Data!B:B = B, Data!C:C = C1)

(Also, there is no need for single quotes around sheet name when it does not contain spaces.)

Best Answer

Related Solutions

Google Sheets – Adding Formulas to Google Forms Responses

Google-sheets – Case insensitive character string filter for multiple individual columns (dynamic input for each)

Related Topic