Home > OS >  How can I combine three ranges in Google Sheets where there isn't always data in two of them an
How can I combine three ranges in Google Sheets where there isn't always data in two of them an

Time:03-10

I have three ranges of data from YouTube that I want to combine into a single table. The three ranges are:

  • YouTube subscriber numbers by day (the days for the combined sheet will pull from here)
  • YouTube videos with lifetime stats and publish date
  • YouTube channel statistics by day

I have data for every day on the first--subscriber numbers--going back years. The videos have the publish date, and I want to do a unique count on videos so that they show on the day they were published (so: "How many videos were published on X date?"). And finally, showing the channel stats by day, which don't go back as far as the subscriber numbers, but will be every day going forward.

Here's an example sheet, open for editing that shows sample data for the three sheets as well as desired output.

enter image description here

Note:

If you want to use this function in any spreadsheet without having to add the function to the associated script, consider deploying this as a Sheets add-on.

Reference:

  • Related