Combine two or more cells and transpose in Google Sheets
=TRANSPOSE(SPLIT(TEXTJOIN(",",1,A1:C1),","))
Embedded Files
Combine two or more cells and transpose in Google Sheets
Combine two or more cells and transpose in Google Sheets
COMBINE TWO OR MORE CELLS AND TRANSPOSE — GOOGLE SHEETS FORMULA AND EXAMPLE
COMBINE TWO OR MORE CELLS AND TRANSPOSE — GOOGLE SHEETS FORMULA AND EXAMPLE
=TRANSPOSE(SPLIT(TEXTJOIN(",",1,A1:C1),","))
A1:C1 = data cell to combine and transpose
1 = ignore_empty, you can use TRUE insisted of 1 as well
"," = delimiter, a string, possibly empty, or a reference to a valid string. If empty, the text will simply be concatenated.
Other useful Excel and Google Sheets to combine cells and columns data
- Combine two or more cell
- Combine multiple columns into one single column
- Combine two or more cells with a line break
- Combine data from multiple Google Sheets tabs and get sheet/tab name
- Sum by month
- SUMIF cells if contains part of a text string
- Sum total sales based on quantity & price
- Combine date and time
- Convert 1-12 to month name
- Dynamic current date and time
- Count blank cell
- Count cell between two values
- Extract left before first space
- Extract the nth words in a text string
- Flip the first and last name
- SUMIF formulas and example
- SUMIFS formulas and example
- COUNTIF formulas and example
- IF formulas and example
- TEXT formulas and example
- CONVERT formulas and example
- Change the negative number to zero
- Change negative to positive numbers
- Calculate percentage changes for containing zero or negative values
- Convert date to text
- Convert time to text
- Convert weekday string to number
- Combine two or more cells and transpose
- Count cells over 10 characters
- Count cells that are not blank
- Count if cells contain a specific text
- Count cells that begin with a specific text
- COUNTIF based on multiple criteria
Google Sites
Report abuse