Check out example codes for "google sheets combine ranges". It will help you in understanding the concepts better.

Code Example 1

-- Google Sheets: Combine ranges
={sheet1!a:a; sheet2!a:a}

Learn ReactJs, React Native from akashmittal.com