Combine two or more cells and transpose in Google Sheets
=TRANSPOSE(SPLIT(TEXTJOIN(",",1,A1:C1),","))
A1:C1 = cell which you want to combine and transpose
Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.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.
Coming | Subscribe here for the custom Excel/Sheets formulas E-book (PDF) >
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