Skip to content

Instantly share code, notes, and snippets.

@aimtiaz11

aimtiaz11/readme.md

Last active June 27, 2024 09:21
Show Gist options
  • Save aimtiaz11/8aeb8b4c4ca06b84780eb2ef15b2173c to your computer and use it in GitHub Desktop.
Save aimtiaz11/8aeb8b4c4ca06b84780eb2ef15b2173c to your computer and use it in GitHub Desktop.
Download ZIP
Google Sheets - Combining Data From Multiple Sheets
Raw
readme.md

Using Arrays and Sorting (removing blank rows) to combine multiple worksheets into one.

=sort({'Feb24 - Data'!A2:G;'Mar24 - Data'!A2:G;'Apr24 - Data'!A2:G;'May24 - Data'!A2:G;'Jun24 - Data'!A2:G})

Source: This awesome video: https://www.youtube.com/watch?v=CVkyfGUSHeg&t=288s

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment