I'm looking for a way to accomplish data binding (join data) in Google sheets. I have two sheets (A = Form Responses and B = Report w/Notes). I need data from sheetA to be moved into sheetB. SheetB needs to bind (join) imported data from sheetA with manually entered data in sheetB. SheetA = From Responses(A)Date     (B)Fname     (C)Lname     (D)ID#1-2-17      Tod          Smith        1234561-3-17      Jen          Jones        2345671-5-17      Bob          Craft        345678SheetB = Report w/Notes- in reverse chronological order(A)Date     (B)Fname     (C)Lname     (D)ID#        (E)Notes1-5-17      Bob          Craft        345678        Good kid1-2-17      Tod          Smith        123456        Always late1-3-17      Jen          Jones        234567        Very helpfulI need the notes column data to bind to the data in columns A-D when a new record is submitted into sheetA and imported into sheetB, the data in column (E)Notes moves down and remains properly aligned with the student data. SheetB = Report w/NotesCURRENT outcome when new record is submitted    (A)Date     (B)Fname     (C)Lname     (D)ID#        (E)Notes    1-7-17      New          Kid          456789        Good kid        1-5-17      Bob          Craft        345678        Always late    1-2-17      Tod          Smith        123456        Very helpful    1-3-17      Jen          Jones        234567        You'll see the new student info is imported into sheetB, but the notes in (E)Notes are not properly aligned with their student.SheetB = Report w/NotesDESIRED outcome when new record is submitted    (A)Date     (B)Fname     (C)Lname     (D)ID#        (E)Notes    1-7-17      New          Kid          456789                1-5-17      Bob          Craft        345678        Good kid    1-2-17      Tod          Smith        123456        Always late    1-3-17      Jen          Jones        234567        Very helpfulYou'll see the new student info is imported into sheetB, and it has been automatically 'moved' down a row so it stays properly aligned with the appropriate student.
I need to bind (join) data in Google Sheets
google spreadsheets