Sunday, July 20, 2014

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   Jul-20-2014
post by archiewood:
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    C
1 David  32   M2 Tom    24   M3 Sarah  27   FTable 2:
  A      B
1 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?