Home > Blockchain >  Google Sheets (Formula or GAScript) - Combine 2 sheets with unique columns into a single sheet
Google Sheets (Formula or GAScript) - Combine 2 sheets with unique columns into a single sheet

Time:03-17

The Problem

I am trying to combine Sheet1 & Sheet2 into Sheet3 sorted by timestamp, but I am unable to adjust the columns so they match between both datasets. Is this even possible with using formulas, or is my only option Google App Scripts?

My Attempt

=query({Sheet1!A2:F;Sheet2!A2:F},"WHERE Col1 is not null ORDER BY Col1")

I have also tried other methods using helper columns, but that did not work very well either.

Spreadsheet:

enter image description here

  • Related