yogi_Combine Two Tables Merge And Sort To Have Multiple Columns For Unique Entities

                                          Google Spreadsheet   Post  #1112
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 11, 2013
user Henrique Vilela :(http://productforums.google.com/forum/?zx=kt0soilg3ufa#!category-topic/docs/spreadsheets/xHyTjuakbkU)
Join two unique results
Hi,

I'm trying to generate an result that is the unique results of a combination of two ranges, something like:

=unique(A1:A joinedwitth C1:C))

Any ideas?

---

My real problem is actually this: http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/how-do-i/desktop/WL_6SIjRkao

As you can see I need to unique join the first two columns "A" to generate the third one.

So: UNIQUE(A,C,D,F + A,B,D,E) = A,B,C,D,E,F

-------------------------------------------------------------------------------------------------------------------

following is my convoluted solution to the problem