I currently have 3 sheets (tabs) in a Google Sheets workbook. Each column header (Row 1) in the 3 sheets are identical. I'd like to create a 4th sheet that combines ALL the contents in the 3 sheets that looks like:

Sheet 1
Sheet 2
Sheet 3

What's the best way to accomplish this? If easier, I do not mind having the header show up 3 times. Thank you.

migrated from superuser.com Feb 6 at 11:14

This question came from our site for computer enthusiasts and power users.


Something like this should work

={'Sheet 1'!1:10000 ; 'Sheet 2'!1:10000 ; 'Sheet 3'!1:10000}
  • Thanks for writing. To confirm, create a 4th tab, and input this formula into cell A1? Throwing an error for me, the formula isn't populating anything. Thoughts? – Jay Feb 3 at 17:32
  • Perhaps, depending on locale, you need to use comma instead of the semicolon. Please share a screenshot of your data, or a copy of your spreadsheet, if you want further help. – ttarchala Feb 4 at 22:58
  • join them as they are by creating the 4th sheet and pasting one of these formulas to A1:

    ={'Sheet 1'!A1:10000\ 'Sheet 2'!A1:10000\ 'Sheet 3'!A1:10000}
    ={'Sheet 1'!A1:10000; 'Sheet 2'!A1:10000; 'Sheet 3'!A1:10000}

  • join them with QUERY() if header for all 3 sheets is the same:

    =QUERY({'Sheet 1'!A1:10000\ 'Sheet 2'!A2:10000\ 'Sheet 3'!A2:10000}; "select *"; 1)

    =QUERY({'Sheet 1'!A1:10000; 'Sheet 2'!A2:10000; 'Sheet 3'!A2:10000}, "select *", 1)

  • join them by skipping empty rows (let's say if data are present column A is always populated):

    change "select *" to "select * where A is not null"

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.