Spreadsheet: 669225d1585251208-auto-update-the-cell-data-from-row-into-columns-for-a-document-record-book-append-query-for-vkmummer
Sheet: Sheet1

NORMAL SHEET
 |  |  |  |  |  |  |  |  | B |  |  |  |  | C |  |  |  |  | D
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21 | Column22 | Column23 | Column24
S/N | Discipline | Document Number | Document Title | Rev | Doc. Submission date | Transmittal Ref. no | Doc. return date | [NAME] | Rev | Doc. Submission date | Transmittal Ref. no | Doc. return date | [NAME] | Rev | Doc. Submission date | Transmittal Ref. no | Doc. return date | [NAME] | Rev | Doc. Submission date | Transmittal Ref. no | Doc. return date | [NAME]
1 | Engg | [NAME] | DOCUMENT REGISTER | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 4
2 | Procedure | ASD2 | PID | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 3 | B | 2019-02-07 00:00:00 | QW002 | 2019-02-28 00:00:00 | 3 | C | 2019-03-04 00:00:00 | QW004 | 2019-03-20 00:00:00 | 3 | D | 2019-04-28 00:00:00 | QW006 | 2019-06-24 00:00:00 | 3
3 | Engg | ASD3 | GAD | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 2 | B | 2019-07-01 00:00:00 | QW003 | 2019-10-17 00:00:00 | 3 | C | 2019-12-11 00:00:00 | QW004 | 2020-01-12 00:00:00 | 3 | D | 2020-01-14 00:00:00 | [NAME] | 2020-02-07 00:00:00 | 3
4 | Procedure | [NAME] | [NAME] | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 3 | B | 2019-02-13 00:00:00 | QW002 | 2019-03-03 00:00:00 | 2 | C | 2019-06-18 00:00:00 | QW003 | 2019-12-18 00:00:00 | 3 | D | 2019-12-24 00:00:00 | [NAME] | 2020-01-14 00:00:00 | 3
 |  | REQUIRED FORMAT
 |  | Document Number | Document Title | Rev | Doc. Submission date | Transmittal Ref. no | Doc. return date | [NAME]
 |  | [NAME] | DOCUMENT REGISTER | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 4
 |  | [NAME] | DOCUMENT REGISTER | B | 2019-02-07 00:00:00 | QW002 | 2019-02-28 00:00:00 | 3
 |  | ASD2 | PID | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 3
 |  | ASD2 | PID | B | 2019-02-07 00:00:00 | QW002 | 2019-02-28 00:00:00 | 3
 |  | ASD2 | PID | C | 2019-03-04 00:00:00 | QW004 | 2019-03-20 00:00:00 | 3
 |  | ASD2 | PID | D | 2019-04-28 00:00:00 | QW006 | 2019-06-24 00:00:00 | 3
 |  | ASD3 | GAD | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 2
 |  | ASD3 | GAD | B | 2019-07-01 00:00:00 | QW003 | 2019-10-17 00:00:00 | 3
 |  | ASD3 | GAD | C | 2019-12-11 00:00:00 | QW004 | 2020-01-12 00:00:00 | 3
 |  | ASD3 | GAD | D | 2020-01-14 00:00:00 | [NAME] | 2020-02-07 00:00:00 | 3
 |  | [NAME] | [NAME] | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 3
 |  | [NAME] | [NAME] | B | 2019-02-13 00:00:00 | QW002 | 2019-03-03 00:00:00 | 2
 |  | [NAME] | [NAME] | C | 2019-06-18 00:00:00 | QW003 | 2019-12-18 00:00:00 | 3
 |  | [NAME] | [NAME] | D | 2019-12-24 00:00:00 | [NAME] | 2020-01-14 00:00:00 | 3
S/N | Discipline | Document Number | Document Title | Rev | Doc. Submission date | Transmittal Ref. no | Doc. return date | [NAME]
1 | Engg | [NAME] | DOCUMENT REGISTER | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 4
2 | Procedure | ASD2 | PID | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 3
3 | Engg | ASD3 | GAD | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 2
4 | Procedure | [NAME] | [NAME] | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 3
1 | Engg | [NAME] | DOCUMENT REGISTER
2 | Procedure | ASD2 | PID | B | 2019-02-07 00:00:00 | QW002 | 2019-02-28 00:00:00 | 3
3 | Engg | ASD3 | GAD | B | 2019-07-01 00:00:00 | QW003 | 2019-10-17 00:00:00 | 3
4 | Procedure | [NAME] | [NAME] | B | 2019-02-13 00:00:00 | QW002 | 2019-03-03 00:00:00 | 2
1 | Engg | [NAME] | DOCUMENT REGISTER
2 | Procedure | ASD2 | PID | C | 2019-03-04 00:00:00 | QW004 | 2019-03-20 00:00:00 | 3
3 | Engg | ASD3 | GAD | C | 2019-12-11 00:00:00 | QW004 | 2020-01-12 00:00:00 | 3
4 | Procedure | [NAME] | [NAME] | C | 2019-06-18 00:00:00 | QW003 | 2019-12-18 00:00:00 | 3
1 | Engg | [NAME] | DOCUMENT REGISTER
2 | Procedure | ASD2 | PID | D | 2019-04-28 00:00:00 | QW006 | 2019-06-24 00:00:00 | 3
3 | Engg | ASD3 | GAD | D | 2020-01-14 00:00:00 | [NAME] | 2020-02-07 00:00:00 | 3
4 | Procedure | [NAME] | [NAME] | D | 2019-12-24 00:00:00 | [NAME] | 2020-01-14 00:00:00 | 3