Spreadsheet: 842787d1694772634-transferring-data-text-from-one-tab-into-another-sample-data
Sheet: Sheet1

Emp Full Name | EmployeeEmail | Assessment | Date
[NAME] | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
Expected OutCome
Emp Full Name | EmployeeEmail | Assessment | Date
[NAME] | [EMAIL] | Remote QNR Assessment 71 | 14/07/2023
[NAME] | [EMAIL] | Remote QNR Assessment 63 | 14/07/2023
[NAME] | [EMAIL] | Remote QNR Assessment 80 | 24/08/2023
[NAME] | [EMAIL] | Remote QNR Assessment 73 | 14/07/2023
 |  |  |  |  |  |  | 6067485
 |  |  |  |  |  |  | 7006682
 |  |  |  |  |  |  | 1001027
 |  |  |  |  |  |  | 2032041
 |  |  |  |  |  |  | 1002367
 |  |  |  |  |  |  | 1003158
 |  |  |  |  |  |  | 6110119
 |  |  |  |  |  |  | 7017865
 |  |  |  |  |  |  | 6069763
 |  |  |  |  |  |  | 7009740
 |  |  |  |  |  |  | 7015994
 |  |  |  |  |  |  | 7018311
 |  |  |  |  |  |  | 7016017
 |  |  |  |  |  |  | 1000495
 |  |  |  |  |  |  | 2041355
 |  |  |  |  |  |  | 7019754
 |  |  |  |  |  |  | 7011093
 |  |  |  |  |  |  | 7010143
 |  |  |  |  |  |  | 7009297
 |  |  |  |  |  |  | 6074147
 |  |  |  |  |  |  | 7007351
 |  |  |  |  |  |  | 6077936
 |  |  |  |  |  |  | 7015764
 |  |  |  |  |  |  | 7014955
 |  |  |  |  |  |  | 7015106
 |  |  |  |  |  |  | 7002265
 |  |  |  |  |  |  | 2232748
 |  |  |  |  |  |  | 2009877
 |  |  |  |  |  |  | 7008689
 |  |  |  |  |  |  | 6064133
 |  |  |  |  |  |  | 7014729
 |  |  |  |  |  |  | 7014730
 |  |  |  |  |  |  | 7015268
 |  |  |  |  |  |  | 7014938
 |  |  |  |  |  |  | 7014693
 |  |  |  |  |  |  | 7005394
 |  |  |  |  |  |  | 1001606
 |  |  |  |  |  |  | 7014973
 |  |  |  |  |  |  | 7009480
 |  |  |  |  |  |  | 7015931
 |  |  |  |  |  |  | 2212170
 |  |  |  |  |  |  | 6055665
 |  |  |  |  |  |  | 7014872
 |  |  |  |  |  |  | 7001007
 |  |  |  |  |  |  | 7008184
 |  |  |  |  |  |  | 7009764
 |  |  |  |  |  |  | 7014727
 |  |  |  |  |  |  | 2012058
 |  |  |  |  |  |  | 2011512
 |  |  |  |  |  |  | 7009744
 |  |  |  |  |  |  | 7015962
 |  |  |  |  |  |  | 7008295
 |  |  |  |  |  |  | 7014717
 |  |  |  |  |  |  | 2013015
 |  |  |  |  |  |  | 6071830
 |  |  |  |  |  |  | 7015884
 |  |  |  |  |  |  | 7002270
 |  |  |  |  |  |  | 6107932
 |  |  |  |  |  |  | 7014706
 |  |  |  |  |  |  | 1743490
 |  |  |  |  |  |  | 6207255
 |  |  |  |  |  |  | 7014722
 |  |  |  |  |  |  | 7009125
 |  |  |  |  |  |  | 6080570
 |  |  |  |  |  |  | 7002928
 |  |  |  |  |  |  | 7003298
 |  |  |  |  |  |  | 2012041
 |  |  |  |  |  |  | 7015422
 |  |  |  |  |  |  | 6209797
 |  |  |  |  |  |  | 1000445
 |  |  |  |  |  |  | 7015690
 |  |  |  |  |  |  | 2012247
 |  |  |  |  |  |  | 7014716
 |  |  |  |  |  |  | 7014712
 |  |  |  |  |  |  | 2041135
 |  |  |  |  |  |  | 6209568
 |  |  |  |  |  |  | 7008086
 |  |  |  |  |  |  | 7012051
 |  |  |  |  |  |  | 7015924
 |  |  |  |  |  |  | 7015945
 |  |  |  |  |  |  | 6201400
 |  |  |  |  |  |  | 2254051
 |  |  |  |  |  |  | 7001598
 |  |  |  |  |  |  | 7014919
 |  |  |  |  |  |  | 6074716
 |  |  |  |  |  |  | 7012098
 |  |  |  |  |  |  | 7005483
 |  |  |  |  |  |  | 7007444
 |  |  |  |  |  |  | 7012928
 |  |  |  |  |  |  | 7011680
 |  |  |  |  |  |  | 1000712
 |  |  |  |  |  |  | 7020981
 |  |  |  |  |  |  | 7001775
 |  |  |  |  |  |  | 7018146
 |  |  |  |  |  |  | 7001267
 |  |  |  |  |  |  | 2019993
 |  |  |  |  |  |  | 7000601
 |  |  |  |  |  |  | 2106796
 |  |  |  |  |  |  | 7008953
 |  |  |  |  |  |  | 7010977
 |  |  |  |  |  |  | 2529743
 |  |  |  |  |  |  | 1003326
 |  |  |  |  |  |  | 7005259
 |  |  |  |  |  |  | 1428102
 |  |  |  |  |  |  | 2034304
 |  |  |  |  |  |  | 7005673
 |  |  |  |  |  |  | 2004800
 |  |  |  |  |  |  | 2137772
 |  |  |  |  |  |  | 1000376
 |  |  |  |  |  |  | 1430441
 |  |  |  |  |  |  | 1339398
 |  |  |  |  |  |  | 1001159
 |  |  |  |  |  |  | 1001855
 |  |  |  |  |  |  | 1507525
 |  |  |  |  |  |  | 7005384
 |  |  |  |  |  |  | 1000277
 |  |  |  |  |  |  | 7006479
 |  |  |  |  |  |  | 7008094
 |  |  |  |  |  |  | 7002577
 |  |  |  |  |  |  | 7012811
 |  |  |  |  |  |  | 6207530
 |  |  |  |  |  |  | 7018871
 |  |  |  |  |  |  | 7019483
 |  |  |  |  |  |  | 7020332
 |  |  |  |  |  |  | 7020470
 |  |  |  |  |  |  | 6208537
 |  |  |  |  |  |  | 7003029
 |  |  |  |  |  |  | 7018306
 |  |  |  |  |  |  | 7020646
 |  |  |  |  |  |  | 2448417
 |  |  |  |  |  |  | 1002343
 |  |  |  |  |  |  | 2005596
 |  |  |  |  |  |  | 7017256
 |  |  |  |  |  |  | 7015923
 |  |  |  |  |  |  | 6202520
 |  |  |  |  |  |  | 6071083
 |  |  |  |  |  |  | 6202296
 |  |  |  |  |  |  | 7020667
 |  |  |  |  |  |  | 6204248
 |  |  |  |  |  |  | 7008132
 |  |  |  |  |  |  | 7010151
 |  |  |  |  |  |  | 7007701
 |  |  |  |  |  |  | 1429478
 |  |  |  |  |  |  | 7008168
 |  |  |  |  |  |  | 1001866
 |  |  |  |  |  |  | 7002283
 |  |  |  |  |  |  | 7020412
 |  |  |  |  |  |  | 7001566
 |  |  |  |  |  |  | 7007718
 |  |  |  |  |  |  | 7009030
 |  |  |  |  |  |  | 7011096
 |  |  |  |  |  |  | 7007276
 |  |  |  |  |  |  | 2232714
 |  |  |  |  |  |  | 1000263
 |  |  |  |  |  |  | 7002342
 |  |  |  |  |  |  | 2125557
 |  |  |  |  |  |  | 6202962
 |  |  |  |  |  |  | 7015958
 |  |  |  |  |  |  | 7009984
 |  |  |  |  |  |  | 7007220
 |  |  |  |  |  |  | 7013816
 |  |  |  |  |  |  | 6209479
 |  |  |  |  |  |  | 1425510
 |  |  |  |  |  |  | 1425251
 |  |  |  |  |  |  | 2460824
 |  |  |  |  |  |  | 7019501
 |  |  |  |  |  |  | 7001412
 |  |  |  |  |  |  | 7009734
 |  |  |  |  |  |  | 2128966
 |  |  |  |  |  |  | 7006541
 |  |  |  |  |  |  | 6211198
 |  |  |  |  |  |  | 7003006
 |  |  |  |  |  |  | 2232789
 |  |  |  |  |  |  | 7003046
 |  |  |  |  |  |  | 7012963
 |  |  |  |  |  |  | 7008362
 |  |  |  |  |  |  | 7014726
 |  |  |  |  |  |  | 7011999
 |  |  |  |  |  |  | 6202792
 |  |  |  |  |  |  | 6072357
 |  |  |  |  |  |  | 7015003
 |  |  |  |  |  |  | 7002524
 |  |  |  |  |  |  | 7020984
 |  |  |  |  |  |  | 1429540
 |  |  |  |  |  |  | 7011088
 |  |  |  |  |  |  | 1003348
 |  |  |  |  |  |  | 7003335
 |  |  |  |  |  |  | 7017919
 |  |  |  |  |  |  | 1431316
 |  |  |  |  |  |  | 7006583
 |  |  |  |  |  |  | 7003180
 |  |  |  |  |  |  | 7013066
 |  |  |  |  |  |  | 7018444
 |  |  |  |  |  |  | 7018436
 |  |  |  |  |  |  | 7010715
 |  |  |  |  |  |  | 6078541
 |  |  |  |  |  |  | 7020619
 |  |  |  |  |  |  | 7019906
 |  |  |  |  |  |  | 7002815
 |  |  |  |  |  |  | 6207921
 |  |  |  |  |  |  | 7007248
 |  |  |  |  |  |  | 2232753
 |  |  |  |  |  |  | 6203527
 |  |  |  |  |  |  | 1001347
 |  |  |  |  |  |  | 7010376
 |  |  |  |  |  |  | 7015002
 |  |  |  |  |  |  | 7006549
 |  |  |  |  |  |  | 7020271
 |  |  |  |  |  |  | 7013814
 |  |  |  |  |  |  | 6062874
 |  |  |  |  |  |  | 1002352
 |  |  |  |  |  |  | 7012985
 |  |  |  |  |  |  | 7007799
 |  |  |  |  |  |  | 7008605
 |  |  |  |  |  |  | 2303990
 |  |  |  |  |  |  | 7013809
 |  |  |  |  |  |  | 2223121
 |  |  |  |  |  |  | 7002224
 |  |  |  |  |  |  | 7018645
 |  |  |  |  |  |  | 7001740
 |  |  |  |  |  |  | 1002872
 |  |  |  |  |  |  | 6064931
 |  |  |  |  |  |  | 7002233
 |  |  |  |  |  |  | 7011105
 |  |  |  |  |  |  | 1750942
 |  |  |  |  |  |  | 7010276
 |  |  |  |  |  |  | 2053541
 |  |  |  |  |  |  | 7007403
 |  |  |  |  |  |  | 7007492
 |  |  |  |  |  |  | 2464617
 |  |  |  |  |  |  | 7003424
 |  |  |  |  |  |  | 7020376
 |  |  |  |  |  |  | 6071873
 |  |  |  |  |  |  | 7002454
 |  |  |  |  |  |  | 2041386
 |  |  |  |  |  |  | 7011546
 |  |  |  |  |  |  | 7005351
 |  |  |  |  |  |  | 7002325
 |  |  |  |  |  |  | 7020631
 |  |  |  |  |  |  | 6203101
 |  |  |  |  |  |  | 1003182
 |  |  |  |  |  |  | 7008119
 |  |  |  |  |  |  | 1634799
 |  |  |  |  |  |  | 7012408
 |  |  |  |  |  |  | 7019138