yogi_Merge Data From Table1 and Table2 With Unequal Number Of Columns Into Table3

                                Google Spreadsheet   Post  #1700
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-20-2014
post by archiewood:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/XgjyZPElVzk)
Combining pages into a single sheet

Hi all,

I've got a sheet with three pages, two of which are populated by (separate) forms. Both forms collect information about the same thing, but one collects less than the other. Form B's fields are all also contained in Form A, but not vice versa.

I would like to be able to combine the two sets of results into one sheet.

Table 1:
  A      B    C1 David  32   M2 Tom    24   M3 Sarah  27   FTable 2:
  A      B1 Alan   32
2 Suzi   25
3 Claire 31
Table 3:
  A      B    C1 David  32   M2 Tom    24   M3 Sarah  27   F4 Alan   32
5 Suzi   25
6 Claire 31


Table 3 above is the target. Is this possible?

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