Questions tagged [concatenate]
Generally, but not necessarily, alongside tag [google-sheets], use this tag when the issue is joining two or more elements into a single element such as with the functions CONCATENATE/JOIN/TEXTJOIN (or CONCAT in Excel) or the operator &.
92 questions
1 vote
1 answer
103 views
How can I insert a line break in a formula in Google Sheets?
I need the A=O to be shown in this 👇🏼 To be shown like this👉🏼 with the final value. Is there any way I can adjust my equation to get this result?, and if not, can someone just me an alternative ...
0 votes
1 answer
49 views
How can I get both of these formulas into one cell?
I want to have both the results 'Follow Up Count' and 'Conversions' to be in the same cell. I've tried various ways of using & and many other ways but I can't seem to get it right. What am I doing ...
1 vote
1 answer
176 views
Splitting hierarchical codes into parent items (Google Sheets)
source cell: CCA, BF result cell: C, CC, CCA, B, BF CCA is a complex code relating to a hierarchy. It means, CCA is child of CC, which is child of C. So, the formula should split into all parents (C ...
- 11
0 votes
1 answer
817 views
Concatenate multiple cells in one cell based on ID
I'm trying to figure out a formula for concatenating data in cells based on a condition. Specifically, I need to output rows for each unique "Conversation ID" (found in column C) and ...
1 vote
1 answer
612 views
Query, Import Range and Concat
I'm wanting to import whole rows of data from 'SPREADSHEET A' to 'SPREADSHEET B' but only if Column 11 in 'SPREADSHEET A' contains the text 'EXPIRED'. The data in 'SPREADSHEET A' contains about 12 ...
- 11
0 votes
2 answers
200 views
concatenation truncating numberic value
in a cell J21 I have entered a numeric value 1.10000. The cell is set to numeric value with 5 decimal places. When using concatenate =CONCATENATE("=CONCATENATE("@ £/€ rate: ",(J21)) in ...
- 581
1 vote
2 answers
280 views
Find and place in a column, the first non-blank cell in each row from a range of columns
I'm attempting to create an ARRAYFORMULA that can extract the first non-blank cell value on each row in a range of columns. My latest attempt is this: =TRANSPOSE(QUERY(TRANSPOSE( A2:D6),"select * ...
- 147
1 vote
2 answers
3k views
Consolidate columns from a dynamic range into a single column in Google Sheets
How can Google Sheets take a range of multiple columns and rows and stack or consolidate all the non-empty cells into one column? For this case, I want non-unique cells. Also, each cell in the range ...
- 163