Spreadsheet: 104768d1302223852-transform-2-column-table-into-1-column-of-data-excel-question-1-
Sheet: Example

 | 1 | 1 | 1 |  |  | Example
 | 2 | 1 | 2
 | 3 | 1 | 3 |  |  | What I have: |  |  |  | Microsoft | Nike | Adidas | [NAME] | Oakley
 | 4 | 1 | 4 |  |  | Account | Entries
 | 5 | 1 | 5 |  |  | Microsoft | 9 |  | 1
 | 6 | 1 | 6 |  |  | Nike | 4 |  | 2
 | 7 | 1 | 7 |  |  | Adidas | 12 |  | 3
 | 8 | 1 | 8 |  |  | [NAME] | 3 |  | 4
 | 9 | 1 | 9 |  |  | Oakley | 2 |  | 5
 | 10 | 1 | 10 |  |  |  |  |  | 6
 | 11 | 1 | 11 |  |  |  |  |  | 7
 | 12 | 1 | 12 |  |  |  |  |  | 8
 | 13 | 1 | 13 |  |  | What I want to turn this into: |  |  | 9
 | 14 | 1 | 14 |  | 1 |  |  |  | 10
 | 15 | 1 | 15 |  | 2 |  |  |  | 11
 | 16 | 1 | 16 |  | 3 |  |  |  | 12
 | 17 | 1 | 17 |  | 4 |  |  |  | 13
 | 18 | 1 | 18 |  | 5 |  |  |  | 14
 | 19 | 1 | 19 |  | 6 |  |  |  | 15
 | 20 | 1 | 20 |  | 7 |  |  |  | 16
 | 21 | 1 | 21 |  | 8 |  |  |  | 17
 | 22 | 1 | 22 |  | 9 |  |  |  | 18
 | 23 | 1 | 23 |  | 10 |  |  |  | 19
 | 24 | 1 | 24 |  | 11 |  |  |  | 20
 | 25 | 1 | 25 |  | 12 |  |  |  | 21
 | 26 | 1 | 26 |  | 13 |  |  |  | 22
 | 27 | 1 | 27 |  | 14 |  |  |  | 23
 | 28 | 1 | 28 |  | 15 |  |  |  | 24
 | 29 | 1 | 29 |  | 16 |  |  |  | 25
 | 30 | 1 | 30 |  | 17 |  |  |  | 26
 | 31 | 1 | 31 |  | 18 |  |  |  | 27
 | 32 | 1 | 32 |  | 19 |  |  |  | 28
 | 33 | 1 | 33 |  | 20 |  |  |  | 29
 | 34 | 1 | 34 |  | 21 |  |  |  | 30
 | 35 | 1 | 35 |  | 22 |  |  |  | 31
 | 36 | 1 | 36 |  | 23 |  |  |  | 32
 | 37 | 1 | 37 |  | 24 |  |  |  | 33
 | 38 | 1 | 38 |  | 25 |  |  |  | 34
 | 39 | 1 | 39 |  | 26 |  |  |  | 35
 | 40 | 1 | 40 |  | 27 |  |  |  | 36
 | 41 | 1 | 41 |  | 28 |  |  |  | 37
 | 42 | 1 | 42 |  | 29 |  |  |  | 38
 | 43 | 1 | 43 |  | 30 |  |  |  | 39
 | 44 | 1 | 44 |  | 31 |  |  |  | 40
 | 45 | 1 | 45 |  | 32 |  |  |  | 41
 | 46 | 1 | 46 |  | 33 |  |  |  | 42
 | 47 | 1 | 47 |  | 34 |  |  |  | 43
 | 48 | 1 | 48 |  | 35 |  |  |  | 44
 | 49 | 1 | 49 |  | 36 |  |  |  | 45
 | 50 | 1 | 50 |  | 37 |  |  |  | 46
 | 1 | 2 | 51 |  | 38 |  |  |  | 47
 | 2 | 2 | 52 |  | 39 |  |  |  | 48
 | 3 | 2 | 53 |  | 40 |  |  |  | 49
 | 4 | 2 | 54 |  | 41 |  |  |  | 50
 | 5 | 2 | 55
 | 6 | 2 | 56
 | 7 | 2 | 57
 | 8 | 2 | 58
 | 9 | 2 | 59
 | 10 | 2 | 60
 | 11 | 2 | 61
 | 12 | 2 | 62
 | 13 | 2 | 63
 | 14 | 2 | 64
 | 15 | 2 | 65
 | 16 | 2 | 66
 | 17 | 2 | 67
 | 18 | 2 | 68
 | 19 | 2 | 69
 | 20 | 2 | 70
 | 21 | 2 | 71
 | 22 | 2 | 72
 | 23 | 2 | 73
 | 24 | 2 | 74
 | 25 | 2 | 75
 | 26 | 2 | 76
 | 27 | 2 | 77
 | 28 | 2 | 78
 | 29 | 2 | 79
 | 30 | 2 | 80
 | 31 | 2 | 81
 | 32 | 2 | 82
 | 33 | 2 | 83
 | 34 | 2 | 84
 | 35 | 2 | 85
 | 36 | 2 | 86
 | 37 | 2 | 87
 | 38 | 2 | 88
 | 39 | 2 | 89
 | 40 | 2 | 90
 | 41 | 2 | 91
 | 42 | 2 | 92
 | 43 | 2 | 93
 | 44 | 2 | 94
 | 45 | 2 | 95
 | 46 | 2 | 96
 | 47 | 2 | 97
 | 48 | 2 | 98
 | 49 | 2 | 99
 | 50 | 2 | 100
 | 1 | 3 | 101
 | 2 | 3 | 102
 | 3 | 3 | 103
 | 4 | 3 | 104
 | 5 | 3 | 105
 | 6 | 3 | 106
 | 7 | 3 | 107
 | 8 | 3 | 108
 | 9 | 3 | 109
 | 10 | 3 | 110
 | 11 | 3 | 111
 | 12 | 3 | 112
 | 13 | 3 | 113
 | 14 | 3 | 114
 | 15 | 3 | 115
 | 16 | 3 | 116
 | 17 | 3 | 117
 | 18 | 3 | 118
 | 19 | 3 | 119
 | 20 | 3 | 120
 | 21 | 3 | 121
 | 22 | 3 | 122
 | 23 | 3 | 123
 | 24 | 3 | 124
 | 25 | 3 | 125
 | 26 | 3 | 126
 | 27 | 3 | 127
 | 28 | 3 | 128
 | 29 | 3 | 129
 | 30 | 3 | 130
 | 31 | 3 | 131
 | 32 | 3 | 132
 | 33 | 3 | 133
 | 34 | 3 | 134
 | 35 | 3 | 135
 | 36 | 3 | 136
 | 37 | 3 | 137
 | 38 | 3 | 138
 | 39 | 3 | 139
 | 40 | 3 | 140
 | 41 | 3 | 141
 | 42 | 3 | 142
 | 43 | 3 | 143
 | 44 | 3 | 144
 | 45 | 3 | 145
 | 46 | 3 | 146
 | 47 | 3 | 147
 | 48 | 3 | 148
 | 49 | 3 | 149
 | 50 | 3 | 150
 | 1 | 4 | 151
 | 2 | 4 | 152
 | 3 | 4 | 153
 | 4 | 4 | 154
 | 5 | 4 | 155
 | 6 | 4 | 156
 | 7 | 4 | 157
 | 8 | 4 | 158
 | 9 | 4 | 159
 | 10 | 4 | 160
 | 11 | 4 | 161
 | 12 | 4 | 162
 | 13 | 4 | 163
 | 14 | 4 | 164
 | 15 | 4 | 165
 | 16 | 4 | 166
 | 17 | 4 | 167
 | 18 | 4 | 168
 | 19 | 4 | 169
 | 20 | 4 | 170
 | 21 | 4 | 171
 | 22 | 4 | 172
 | 23 | 4 | 173
 | 24 | 4 | 174
 | 25 | 4 | 175
 | 26 | 4 | 176
 | 27 | 4 | 177
 | 28 | 4 | 178
 | 29 | 4 | 179
 | 30 | 4 | 180
 | 31 | 4 | 181
 | 32 | 4 | 182
 | 33 | 4 | 183
 | 34 | 4 | 184
 | 35 | 4 | 185
 | 36 | 4 | 186
 | 37 | 4 | 187
 | 38 | 4 | 188
 | 39 | 4 | 189
 | 40 | 4 | 190
 | 41 | 4 | 191
 | 42 | 4 | 192
 | 43 | 4 | 193
 | 44 | 4 | 194
 | 45 | 4 | 195
 | 46 | 4 | 196
 | 47 | 4 | 197
 | 48 | 4 | 198
 | 49 | 4 | 199
 | 50 | 4 | 200
 | 1 | 5 | 201
 | 2 | 5 | 202
 | 3 | 5 | 203
 | 4 | 5 | 204
 | 5 | 5 | 205
 | 6 | 5 | 206
 | 7 | 5 | 207
 | 8 | 5 | 208
 | 9 | 5 | 209
 | 10 | 5 | 210
 | 11 | 5 | 211
 | 12 | 5 | 212
 | 13 | 5 | 213
 | 14 | 5 | 214
 | 15 | 5 | 215
 | 16 | 5 | 216
 | 17 | 5 | 217
 | 18 | 5 | 218
 | 19 | 5 | 219
 | 20 | 5 | 220
 | 21 | 5 | 221
 | 22 | 5 | 222
 | 23 | 5 | 223
 | 24 | 5 | 224
 | 25 | 5 | 225
 | 26 | 5 | 226
 | 27 | 5 | 227
 | 28 | 5 | 228
 | 29 | 5 | 229
 | 30 | 5 | 230
 | 31 | 5 | 231
 | 32 | 5 | 232
 | 33 | 5 | 233
 | 34 | 5 | 234
 | 35 | 5 | 235
 | 36 | 5 | 236
 | 37 | 5 | 237
 | 38 | 5 | 238
 | 39 | 5 | 239
 | 40 | 5 | 240
 | 41 | 5 | 241
 | 42 | 5 | 242
 | 43 | 5 | 243
 | 44 | 5 | 244
 | 45 | 5 | 245
 | 46 | 5 | 246
 | 47 | 5 | 247
 | 48 | 5 | 248
 | 49 | 5 | 249
 | 50 | 5 | 250