Spreadsheet: 88382d1288209451-transpose-a-list-after-population-test2
Sheet: Sheet1

 |  |  |  |  |  |  | I would like to automatically transpose this list as it populates on Row 1. Is this possible?
 |  |  |  |  |  | 22
 |  |  | 197062 |  | 1 | 197062 | 195850
 |  |  | 197062 |  | 2 | 206193 | 197044
 |  |  | 197062 |  | 3 | 201162 | 197062
 |  |  | 197062 |  | 4 | 197491 | 197491
 |  |  | 197062 |  | 5 | 201161 | 197515
 |  |  | 197062 |  | 6 | 197529 | 197517
 |  |  | 206193 |  | 7 | 197517 | 197529
 |  |  | 206193 |  | 8 | 197553 | 197532
 |  |  | 206193 |  | 9 | 197556 | 197553
 |  |  | 206193 |  | 10 | 197515 | 197556
 |  |  | 206193 |  | 11 | 195850 | 197560
 |  |  | 197062 |  | 12 | 203438 | 201161
 |  |  | 197062 |  | 13 | 197560 | 201162
 |  |  | 197062 |  | 14 | 197532 | 201177
 |  |  | 197062 |  | 15 | 197044 | 203438
 |  |  | 197062 |  | 16 | 203455 | 203449
 |  |  | 197062 |  | 17 | 203578 | 203455
 |  |  | 197062 |  | 18 | 203577 | 203577
 |  |  | 197062 |  | 19 | 207385 | 203578
 |  |  | 197062 |  | 20 | 207857 | 206193
 |  |  | 197062 |  | 21 | 203449 | 207385
 |  |  | 197062 |  | 22 | 201177 | 207857
 |  |  | 197062 |  | 23
 |  |  | 197062 |  | 24
 |  |  | 197062 |  | 25
 |  |  | 197062 |  | 26
 |  |  | 197062 |  | 27
 |  |  | 206193 |  | 28
 |  |  | 206193 |  | 29
 |  |  | 206193 |  | 30
 |  |  |  |  | 31
 |  |  | 206193 |  | 32
 |  |  | 206193 |  | 33
 |  |  | 206193 |  | 34
 |  |  | 201162 |  | 35
 |  |  | 201162 |  | 36
 |  |  | 201162 |  | 37
 |  |  | 201162 |  | 38
 |  |  | 197491 |  | 39
 |  |  | 197491 |  | 40
 |  |  | 197491 |  | 41
 |  |  | 197491 |  | 42
 |  |  | 197491 |  | 43
 |  |  | 197491 |  | 44
 |  |  | 197491 |  | 45
 |  |  | 201162 |  | 46
 |  |  | 201162 |  | 47
 |  |  | 197062 |  | 48
 |  |  | 197062 |  | 49
 |  |  | 197062 |  | 50
 |  |  | 197491 |  | 51
 |  |  | 197491 |  | 52
 |  |  | 197491 |  | 53
 |  |  | 197491 |  | 54
 |  |  | 197491 |  | 55
 |  |  | 197491 |  | 56
 |  |  | 197491 |  | 57
 |  |  | 197491 |  | 58
 |  |  | 197491 |  | 59
 |  |  | 197491 |  | 60
 |  |  | 197491 |  | 61
 |  |  |  |  | 62
 |  |  | 197062 |  | 63
 |  |  | 197062 |  | 64
 |  |  | 197062 |  | 65
 |  |  | 197062 |  | 66
 |  |  | 197062 |  | 67
 |  |  | 197062 |  | 68
 |  |  | 197062 |  | 69
 |  |  | 197062 |  | 70
 |  |  | 197062 |  | 71
 |  |  | 197062 |  | 72
 |  |  | 201161 |  | 73
 |  |  | 201161 |  | 74
 |  |  | 201161 |  | 75
 |  |  | 201161 |  | 76
 |  |  | 201161 |  | 77
 |  |  | 206193 |  | 78
 |  |  | 206193 |  | 79
 |  |  | 206193 |  | 80
 |  |  | 206193 |  | 81
 |  |  | 197062 |  | 82
 |  |  | 197062 |  | 83
 |  |  | 197062 |  | 84
 |  |  | 197062 |  | 85
 |  |  | 197062 |  | 86
 |  |  | 197062 |  | 87
 |  |  | 206193 |  | 88
 |  |  | 206193 |  | 89
 |  |  | 206193 |  | 90
 |  |  | 206193 |  | 91
 |  |  | 206193 |  | 92
 |  |  |  |  | 93
 |  |  | 197529 |  | 94
 |  |  | 197529 |  | 95
 |  |  | 197529 |  | 96
 |  |  | 197529 |  | 97
 |  |  | 197517 |  | 98
 |  |  | 197517 |  | 99
 |  |  | 197553 |  | 100
 |  |  | 197553 |  | 101
 |  |  | 197553 |  | 102
 |  |  | 197553 |  | 103
 |  |  | 197556 |  | 104
 |  |  | 197556
 |  |  | 197515
 |  |  | 197515
 |  |  | 197515
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 203438
 |  |  | 203438
 |  |  | 203438
 |  |  | 203438
 |  |  | 197560
 |  |  | 197532
 |  |  | 197532
 |  |  | 197044
 |  |  | 197044
 |  |  | 197044
 |  |  | 197044
 |  |  | 197044
 |  |  | 197044
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 195850
 |  |  | 203438
 |  |  | 203438
 |  |  | 203438
 |  |  | 203438
 |  |  | 203438
 |  |  | 203438
 |  |  | 197560
 |  |  | 203455
 |  |  | 203455
 |  |  | 203578
 |  |  | 203578
 |  |  | 203578
 |  |  | 203578
 |  |  | 203578
 |  |  | 203577
 |  |  | 203577
 |  |  | 203577
 |  |  | 203577
 |  |  | 203577
 |  |  | 203577
 |  |  | 203577
 |  |  | 203577
 |  |  | 203455
 |  |  | 203455
 |  |  | 203455
 |  |  | 203455
 |  |  | 203455
 |  |  | 207385
 |  |  | 207385
 |  |  | 207385
 |  |  | 207385
 |  |  | 207385
 |  |  | 207857
 |  |  | 207857
 |  |  | 207857
 |  |  | 207857
 |  |  | 207857
 |  |  | 207385
 |  |  | 207385
 |  |  | 207385
 |  |  | 207385
 |  |  | 207385
 |  |  | 207857
 |  |  | 207857
 |  |  | 207857
 |  |  | 207857
 |  |  | 207857
 |  |  | 203449
 |  |  | 203449
 |  |  | 203449
 |  |  | 203449
 |  |  | 203449
 |  |  | 201177
 |  |  | 201177
 |  |  | 201177
 |  |  | 201177
 |  |  | 201177
 |  |  | 201177
 |  |  | 201177
 |  |  | 201177
 |  |  | 201177
 |  |  | 201177
 |  |  | 201177
 |  |  | 201177
 |  |  | 201177
 |  |  | 201177
 |  |  | 201177