Sunday, February 26, 2017

yogi_Merge Data From Two Tabs And Sort By date Column In Ascending Order

Google Spreadsheet   Post  #2123
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-26-2017
question by Wolfeyes82:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/lyHGLb6d8Xo;context-place=mydiscussions
How do you use VMerge, omit blank rows, and sort results?
Ok, I tried to find a previous version of this question with no luck. Basically, I'm using Vmerge to bring in two different ranges and omit/without blank rows. Here is my current formula:
=QUERY(vmerge(Farming!B:D,Transactions!A2:C1000),"select * where Col1 is not null")

Now I just need the results to be sorted by column1. I thought it would be easy, I am an amateur trying to learn.

I can't just make it a table and sort by column1 because it still returns the first range and then the second range.