Google-sheets – How to concatenate the data in column B based on the data from column A

concatenategoogle sheets

I'd like to turn the image below:

into the following:

A1: Yellow // B1: The quick brown fox jumps over the lazy dog.
A2: Blue // B2: The earliest known appearance of the phrase is from The Boston Journal.

Best Answer

You might try:

=join(" ",FILTER(B:B,A:A=A1))

copied down to suit (I haven't because you data sample lacks consideration for those who rely on screen readers) then Copy/Paste special values only over the top and if say in ColumnC then:

 =unique(C:C)

Copy/Paste special values only over the top again and delete surplus.

Related Solutions

Google Sheets – Concatenate Data from Multiple Columns

This can be done with an arrayformula as follows:

=arrayformula(importrange("URL", "A1:A3") & " " & importrange("URL", "B1:B3"))

The inner part describes what should be done within one row; the arrayformula then says "do it for every row".

Google-sheets – How to concatenate date value with a string

You need to convert the date value to a string of the form yyyymmdd. The text formula does this:

=text(today(), "yyyymmdd")

(It's better to use today() instead of now() when you want the date only.)

The entire formula would be

=concatenate("ABC", text(today(), "yyyymmdd"), 123)

or, more concisely,

="ABC" & text(today(), "yyyymmdd") & 123

Best Answer

Related Solutions

Google Sheets – Concatenate Data from Multiple Columns

Google-sheets – How to concatenate date value with a string

Related Topic