Number of columns in both sheets must be the same:
Try
={Sheet1!A2:D10;Sheet2!A2:D10}
More Related Contents:
- ArrayFormula of Average on Infinite Truly Dynamic Range in Google Sheets
- ArrayFormula and “AND” Formula in Google Sheets
- ARRAY_LITERAL, an Array Literal was missing values for one or more rows
- How to use arrayformula with formulas that do not seem to support arrayformulas?
- Conditional formatting based on another cell’s value
- Google Sheets importXML Returns Empty Value
- Get the last non-empty cell in a column in Google Sheets
- How to stop / freeze / pause volatile RAND / RANDBETWEEN / RANDARRAY?
- How would I import YouTube Likes and Dislikes and a ratio from YouTube onto Google Sheets? [closed]
- How to SUM duration in Google Sheets?
- Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
- Selecting the last value of a column
- Difference between two dates expressed as years, months, days (in one column)
- Query is ignoring string (non numeric) value
- Repeat whole row N times based on column value in Google Sheets
- I get Formula parse error with all formulas
- IMPORTXML and right XPath from Bloomberg price [duplicate]
- What factors determine the memory used in lambda functions?
- How to list all permutations without repetition?
- Repeat each row N times in Google Sheets
- Google Sheets Formula for Extracting Domain From Website?
- How to create all possible pair combinations without duplicates in Google Sheets?
- Col BY causing parse error in Google sheets query
- Count cells that contain any text
- How to make a range repeat n-times in Google SpreadSheet
- How to create INDIRECT array string of multiple sheet references in Google Sheets?
- QUERY and order by the first date of column
- ultimate short custom number formatting – K, M, B, T, etc., Q, D, Googol
- How to Autofill last row with formula, when data is received from IFTTT on the last row?
- Download link for Google Spreadsheets CSV export – with Multiple Sheets