From main menu Worksheet: Join Worksheets by Column will open this new tool.

• Support two input worksheets to be joined.

• Support multiple matching columns.

• Support drop non-matches and drop multiples for each input sheet.

• Support drop multiples by merged value.

• Support sort output by specified column.

• Support output additional info to column label to indicate different source.

• Support query language like SQL to join columns. See following example,

  wjoincols -r 2 irng:=([Book1]Sheet1,[Book2]Sheet1) 
  query:="w1 inner join w2 on w1.A=w2.A and w1.B=w2.B order by match asc w1 merge multiples by first row";
  //Join method supported: Inner Join, Left Join, Right Join, Full Outer Join