Spreadsheet: 296552d1392127236-reorganizing-data-to-show-info-from-two-separate-columns-in-a-third-new-column-template-for-macro
Sheet: Sheet1

participant | Target Letter Number | Response letter number | t2 orientation | t2 response | num letter prior t1 | num letter post t1 | when t2 (lag) | response 1 frames | response 2 frames | t1 correct | t2 correct | VGP | VGP Type | Gender | single_dual |  | lag_1 | lag_2 | lag_3 | lag_4 | lag_5 | lag_6 | lag_7 | lag_8 |  | correct orientations
1 |  |  |  |  |  |  | 1 |  |  |  | 1
1 |  |  |  |  |  |  | 1 |  |  |  | 1
1 |  |  |  |  |  |  | 7 |  |  |  | 1
1 |  |  |  |  |  |  | 5 |  |  |  | 1
1 |  |  |  |  |  |  | 8 |  |  |  | 1
1 |  |  |  |  |  |  | 3 |  |  |  | 1
1 |  |  |  |  |  |  | 2 |  |  |  | 0
1 |  |  |  |  |  |  | 5 |  |  |  | 0
1 |  |  |  |  |  |  | 6 |  |  |  | 1
1 |  |  |  |  |  |  | 8 |  |  |  | 0
1 |  |  |  |  |  |  | 5 |  |  |  | 1
1 |  |  |  |  |  |  | 6 |  |  |  | 1
1 |  |  |  |  |  |  | 4 |  |  |  | 1
1 |  |  |  |  |  |  | 3 |  |  |  | 0
1 |  |  |  |  |  |  | 8 |  |  |  | 1
1 |  |  |  |  |  |  | 5 |  |  |  | 1
1 |  |  |  |  |  |  | 3 |  |  |  | 1
1 |  |  |  |  |  |  | 2 |  |  |  | 1
1 |  |  |  |  |  |  | 6 |  |  |  | 1
1 |  |  |  |  |  |  | 5 |  |  |  | 1
1 |  |  |  |  |  |  | 1 |  |  |  | 1
1 |  |  |  |  |  |  | 2 |  |  |  | 1
1 |  |  |  |  |  |  | 2 |  |  |  | 0
1 |  |  |  |  |  |  | 4 |  |  |  | 0
1 |  |  |  |  |  |  | 6 |  |  |  | 1
1 |  |  |  |  |  |  | 2 |  |  |  | 0
1 |  |  |  |  |  |  | 3 |  |  |  | 1
1 |  |  |  |  |  |  | 5 |  |  |  | 1
1 |  |  |  |  |  |  | 8 |  |  |  | 1
1 |  |  |  |  |  |  | 4 |  |  |  | 0
1 |  |  |  |  |  |  | 6 |  |  |  | 1
1 |  |  |  |  |  |  | 2 |  |  |  | 1
1 |  |  |  |  |  |  | 1 |  |  |  | 1
1 |  |  |  |  |  |  | 1 |  |  |  | 1
1 |  |  |  |  |  |  | 7 |  |  |  | 1
1 |  |  |  |  |  |  | 2 |  |  |  | 1
1 |  |  |  |  |  |  | 7 |  |  |  | 1
1 |  |  |  |  |  |  | 1 |  |  |  | 1
1 |  |  |  |  |  |  | 3 |  |  |  | 0
1 |  |  |  |  |  |  | 5 |  |  |  | 0
1 |  |  |  |  |  |  | 8 |  |  |  | 1
1 |  |  |  |  |  |  | 6 |  |  |  | 0
1 |  |  |  |  |  |  | 3 |  |  |  | 1
1 |  |  |  |  |  |  | 1 |  |  |  | 1
1 |  |  |  |  |  |  | 1 |  |  |  | 1
1 |  |  |  |  |  |  | 5 |  |  |  | 0
1 |  |  |  |  |  |  | 1 |  |  |  | 1
1 |  |  |  |  |  |  | 7 |  |  |  | 1
1 |  |  |  |  |  |  | 8 |  |  |  | 1
1 |  |  |  |  |  |  | 4 |  |  |  | 1
1 |  |  |  |  |  |  | 8 |  |  |  | 1
1 |  |  |  |  |  |  | 3 |  |  |  | 1
1 |  |  |  |  |  |  | 3 |  |  |  | 1
1 |  |  |  |  |  |  | 5 |  |  |  | 1
1 |  |  |  |  |  |  | 7 |  |  |  | 0
1 |  |  |  |  |  |  | 8 |  |  |  | 0
1 |  |  |  |  |  |  | 7 |  |  |  | 1
1 |  |  |  |  |  |  | 4 |  |  |  | 0
1 |  |  |  |  |  |  | 3 |  |  |  | 1
1 |  |  |  |  |  |  | 7 |  |  |  | 1
1 |  |  |  |  |  |  | 5 |  |  |  | 1
1 |  |  |  |  |  |  | 4 |  |  |  | 0
1 |  |  |  |  |  |  | 7 |  |  |  | 1
1 |  |  |  |  |  |  | 1 |  |  |  | 1
1 |  |  |  |  |  |  | 7 |  |  |  | 1
1 |  |  |  |  |  |  | 6 |  |  |  | 1
1 |  |  |  |  |  |  | 6 |  |  |  | 1
1 |  |  |  |  |  |  | 1 |  |  |  | 1
1 |  |  |  |  |  |  | 2 |  |  |  | 1
1 |  |  |  |  |  |  | 1 |  |  |  | 1
1 |  |  |  |  |  |  | 5 |  |  |  | 0
1 |  |  |  |  |  |  | 3 |  |  |  | 0
1 |  |  |  |  |  |  | 4 |  |  |  | 1
1 |  |  |  |  |  |  | 2 |  |  |  | 0
1 |  |  |  |  |  |  | 5 |  |  |  | 1
1 |  |  |  |  |  |  | 3 |  |  |  | 1
1 |  |  |  |  |  |  | 7 |  |  |  | 1
1 |  |  |  |  |  |  | 4 |  |  |  | 0
1 |  |  |  |  |  |  | 2 |  |  |  | 1
1 |  |  |  |  |  |  | 7 |  |  |  | 1
1 |  |  |  |  |  |  | 6 |  |  |  | 1
1 |  |  |  |  |  |  | 8 |  |  |  | 1
1 |  |  |  |  |  |  | 6 |  |  |  | 1
1 |  |  |  |  |  |  | 3 |  |  |  | 1
1 |  |  |  |  |  |  | 4 |  |  |  | 1
1 |  |  |  |  |  |  | 2 |  |  |  | 1
1 |  |  |  |  |  |  | 8 |  |  |  | 0
1 |  |  |  |  |  |  | 8 |  |  |  | 0
1 |  |  |  |  |  |  | 8 |  |  |  | 1
1 |  |  |  |  |  |  | 7 |  |  |  | 0
1 |  |  |  |  |  |  | 6 |  |  |  | 1
1 |  |  |  |  |  |  | 2 |  |  |  | 1
1 |  |  |  |  |  |  | 6 |  |  |  | 1
1 |  |  |  |  |  |  | 4 |  |  |  | 0
1 |  |  |  |  |  |  | 4 |  |  |  | 1
1 |  |  |  |  |  |  | 4 |  |  |  | 1