Spreadsheet: 789554d1659181128-formula-to-make-a-single-column-from-multiple-small-columns-skipping-even-number-columns-daf-filter-odd-columns-to-single-column-aligw
Sheet: Sheet1

1 | 2022-05-01 22:05:00 | 18 | 2022-05-02 00:00:00 | 43 | 2022-05-03 00:00:00 | 63 | 2022-05-04 00:00:00 | 85 | 2022-05-05 00:00:00 | 99 | 2022-05-06 00:00:00 | 115 | 2022-05-08 22:05:00 | 126 | 2022-05-09 00:00:00 | 130 | 2022-05-10 00:00:00 | 135 | 2022-05-11 00:00:00 | 144 | 2022-05-12 00:00:00 | 156 | 2022-05-13 00:00:00 | 162 | 2022-05-15 22:05:00 | 170 | 2022-05-16 00:00:00 | 182 | 2022-05-17 00:00:00 | 199 | 2022-05-18 00:00:00 | 218 | 2022-05-19 00:00:00 | 230 | 2022-05-20 00:00:00 | 243 | 2022-05-22 22:05:00 | 258 | 2022-05-23 00:00:00 | 266 | 2022-05-24 00:00:00 | 276 | 2022-05-25 00:00:00 | 289 | 2022-05-26 00:00:00 | 306 | 2022-05-27 00:00:00 | 318 | 2022-05-29 22:05:01 | 332 | 2022-05-30 00:00:00 | 348 | 2022-05-31 00:00:00
2 | 2022-05-01 22:05:00 | 19 | 2022-05-02 00:00:00 | 44 | 2022-05-03 00:00:00 | 64 | 2022-05-04 00:00:00 | 86 | 2022-05-05 00:00:00 | 100 | 2022-05-06 00:00:00 | 116 | 2022-05-08 22:05:00 | 127 | 2022-05-09 00:00:00 | 131 | 2022-05-10 00:00:00 | 136 | 2022-05-11 00:00:00 | 145 | 2022-05-12 00:00:00 | 157 | 2022-05-13 00:00:00 | 163 | 2022-05-15 22:05:00 | 171 | 2022-05-16 00:00:00 | 183 | 2022-05-17 00:00:00 | 200 | 2022-05-18 00:00:00 | 219 | 2022-05-19 00:00:00 | 231 | 2022-05-20 00:00:00 | 244 | 2022-05-22 22:05:00 | 259 | 2022-05-23 00:00:00 | 267 | 2022-05-24 00:00:00 | 277 | 2022-05-25 00:00:00 | 290 | 2022-05-26 00:00:00 | 307 | 2022-05-27 00:00:00 | 319 | 2022-05-29 22:05:01 | 333 | 2022-05-30 00:00:00 | 349 | 2022-05-31 00:00:00
3 | 2022-05-01 22:05:00 | 20 | 2022-05-02 00:00:00 | 45 | 2022-05-03 00:00:00 | 65 | 2022-05-04 00:00:00 | 87 | 2022-05-05 00:00:00 | 101 | 2022-05-06 00:00:00 | 117 | 2022-05-08 22:05:00 | 128 | 2022-05-09 00:00:00 | 132 | 2022-05-10 00:00:00 | 137 | 2022-05-11 00:00:00 | 146 | 2022-05-12 00:00:00 | 158 | 2022-05-13 00:00:00 | 164 | 2022-05-15 22:05:00 | 172 | 2022-05-16 00:00:00 | 184 | 2022-05-17 00:00:00 | 201 | 2022-05-18 00:00:00 | 220 | 2022-05-19 00:00:00 | 232 | 2022-05-20 00:00:00 | 245 | 2022-05-22 22:05:00 | 260 | 2022-05-23 00:00:00 | 268 | 2022-05-24 00:00:00 | 278 | 2022-05-25 00:00:00 | 291 | 2022-05-26 00:00:00 | 308 | 2022-05-27 00:00:00 | 320 | 2022-05-29 22:05:01 | 334 | 2022-05-30 00:00:00 | 350 | 2022-05-31 00:00:00
4 | 2022-05-01 22:05:00 | 21 | 2022-05-02 00:00:00 | 46 | 2022-05-03 00:00:00 | 66 | 2022-05-04 00:00:00 | 88 | 2022-05-05 00:00:00 | 102 | 2022-05-06 00:00:00 | 118 | 2022-05-08 22:05:00 | 129 | 2022-05-09 00:00:00 | 133 | 2022-05-10 00:00:00 | 138 | 2022-05-11 00:00:00 | 147 | 2022-05-12 00:00:00 | 159 | 2022-05-13 00:00:00 | 165 | 2022-05-15 22:05:00 | 173 | 2022-05-16 00:00:00 | 185 | 2022-05-17 00:00:00 | 202 | 2022-05-18 00:00:00 | 221 | 2022-05-19 00:00:00 | 233 | 2022-05-20 00:00:00 | 246 | 2022-05-22 22:05:00 | 261 | 2022-05-23 00:00:00 | 269 | 2022-05-24 00:00:00 | 279 | 2022-05-25 00:00:00 | 292 | 2022-05-26 00:00:00 | 309 | 2022-05-27 00:00:00 | 321 | 2022-05-29 22:05:01 | 335 | 2022-05-30 00:00:00 | 351 | 2022-05-31 00:00:00
5 | 2022-05-01 22:05:00 | 22 | 2022-05-02 00:00:00 | 47 | 2022-05-03 00:00:00 | 67 | 2022-05-04 00:00:00 | 89 | 2022-05-05 00:00:00 | 103 | 2022-05-06 00:00:00 | 119 | 2022-05-08 22:05:00 |  |  | 134 | 2022-05-10 00:00:00 | 139 | 2022-05-11 00:00:00 | 148 | 2022-05-12 00:00:00 | 160 | 2022-05-13 00:00:00 | 166 | 2022-05-15 22:05:00 | 174 | 2022-05-16 00:00:00 | 186 | 2022-05-17 00:00:00 | 203 | 2022-05-18 00:00:00 | 222 | 2022-05-19 00:00:00 | 234 | 2022-05-20 00:00:00 | 247 | 2022-05-22 22:05:00 | 262 | 2022-05-23 00:00:00 | 270 | 2022-05-24 00:00:00 | 280 | 2022-05-25 00:00:00 | 293 | 2022-05-26 00:00:00 | 310 | 2022-05-27 00:00:00 | 322 | 2022-05-29 22:05:01 | 336 | 2022-05-30 00:00:00 | 352 | 2022-05-31 00:00:00
6 | 2022-05-01 22:05:00 | 23 | 2022-05-02 00:00:00 | 48 | 2022-05-03 00:00:00 | 68 | 2022-05-04 00:00:00 | 90 | 2022-05-05 00:00:00 | 104 | 2022-05-06 00:00:00 | 120 | 2022-05-08 22:05:01 |  |  |  |  | 140 | 2022-05-11 00:00:00 | 149 | 2022-05-12 00:00:00 | 161 | 2022-05-13 00:00:00 | 167 | 2022-05-15 22:05:00 | 175 | 2022-05-16 00:00:00 | 187 | 2022-05-17 00:00:00 | 204 | 2022-05-18 00:00:00 | 223 | 2022-05-19 00:00:00 | 235 | 2022-05-20 00:00:00 | 248 | 2022-05-22 22:05:00 | 263 | 2022-05-23 00:00:00 | 271 | 2022-05-24 00:00:00 | 281 | 2022-05-25 00:00:00 | 294 | 2022-05-26 00:00:00 | 311 | 2022-05-27 00:00:00 | 323 | 2022-05-29 22:05:01 | 337 | 2022-05-30 00:00:00 | 353 | 2022-05-31 00:00:00
7 | 2022-05-01 22:05:00 | 24 | 2022-05-02 00:00:00 | 49 | 2022-05-03 00:00:00 | 69 | 2022-05-04 00:00:01 | 91 | 2022-05-05 00:00:00 | 105 | 2022-05-06 00:00:00 | 121 | 2022-05-08 22:05:01 |  |  |  |  | 141 | 2022-05-11 00:00:00 | 150 | 2022-05-12 00:00:00 |  |  | 168 | 2022-05-15 22:05:01 | 176 | 2022-05-16 00:00:00 | 188 | 2022-05-17 00:00:00 | 205 | 2022-05-18 00:00:00 | 224 | 2022-05-19 00:00:00 | 236 | 2022-05-20 00:00:00 | 249 | 2022-05-22 22:05:00 | 264 | 2022-05-23 00:00:00 | 272 | 2022-05-24 00:00:00 | 282 | 2022-05-25 00:00:00 | 295 | 2022-05-26 00:00:00 | 312 | 2022-05-27 00:00:01 | 324 | 2022-05-29 22:05:01 | 338 | 2022-05-30 00:00:00 | 354 | 2022-05-31 00:00:00
8 | 2022-05-01 22:05:00 | 25 | 2022-05-02 00:00:00 | 50 | 2022-05-03 00:00:00 | 70 | 2022-05-04 00:00:01 | 92 | 2022-05-05 00:00:00 | 106 | 2022-05-06 00:00:00 | 122 | 2022-05-08 22:05:01 |  |  |  |  | 142 | 2022-05-11 00:00:00 | 151 | 2022-05-12 00:00:00 |  |  | 169 | 2022-05-15 22:05:01 | 177 | 2022-05-16 00:00:00 | 189 | 2022-05-17 00:00:00 | 206 | 2022-05-18 00:00:00 | 225 | 2022-05-19 00:00:00 | 237 | 2022-05-20 00:00:01 | 250 | 2022-05-22 22:05:00 | 265 | 2022-05-23 00:00:00 | 273 | 2022-05-24 00:00:00 | 283 | 2022-05-25 00:00:00 | 296 | 2022-05-26 00:00:00 | 313 | 2022-05-27 00:00:01 | 325 | 2022-05-29 22:05:02 | 339 | 2022-05-30 00:00:00
9 | 2022-05-01 22:05:01 | 26 | 2022-05-02 00:00:00 | 51 | 2022-05-03 00:00:00 | 71 | 2022-05-04 00:00:01 | 93 | 2022-05-05 00:00:00 | 107 | 2022-05-06 00:00:00 | 123 | 2022-05-08 22:05:02 |  |  |  |  | 143 | 2022-05-11 00:00:00 | 152 | 2022-05-12 00:00:00 |  |  |  |  | 178 | 2022-05-16 00:00:00 | 190 | 2022-05-17 00:00:00 | 207 | 2022-05-18 00:00:00 | 226 | 2022-05-19 00:00:00 | 238 | 2022-05-20 00:00:01 | 251 | 2022-05-22 22:05:00 |  |  | 274 | 2022-05-24 00:00:01 | 284 | 2022-05-25 00:00:00 | 297 | 2022-05-26 00:00:00 | 314 | 2022-05-27 00:00:01 | 326 | 2022-05-29 22:05:02 | 340 | 2022-05-30 00:00:00
10 | 2022-05-01 22:05:01 | 27 | 2022-05-02 00:00:00 | 52 | 2022-05-03 00:00:00 | 72 | 2022-05-04 00:00:01 | 94 | 2022-05-05 00:00:00 | 108 | 2022-05-06 00:00:00 | 124 | 2022-05-08 22:05:02 |  |  |  |  |  |  | 153 | 2022-05-12 00:00:00 |  |  |  |  | 179 | 2022-05-16 00:00:00 | 191 | 2022-05-17 00:00:00 | 208 | 2022-05-18 00:00:00 | 227 | 2022-05-19 00:00:00 | 239 | 2022-05-20 00:00:01 | 252 | 2022-05-22 22:05:00 |  |  | 275 | 2022-05-24 00:00:01 | 285 | 2022-05-25 00:00:00 | 298 | 2022-05-26 00:00:01 | 315 | 2022-05-27 00:00:01 | 327 | 2022-05-29 22:05:03 | 341 | 2022-05-30 00:00:00
11 | 2022-05-01 22:05:01 | 28 | 2022-05-02 00:00:00 | 53 | 2022-05-03 00:00:00 | 73 | 2022-05-04 00:00:01 | 95 | 2022-05-05 00:00:00 | 109 | 2022-05-06 00:00:01 | 125 | 2022-05-08 22:05:02 |  |  |  |  |  |  | 154 | 2022-05-12 00:00:00 |  |  |  |  | 180 | 2022-05-16 00:00:01 | 192 | 2022-05-17 00:00:00 | 209 | 2022-05-18 00:00:01 | 228 | 2022-05-19 00:00:00 | 240 | 2022-05-20 00:00:01 | 253 | 2022-05-22 22:05:00 |  |  |  |  | 286 | 2022-05-25 00:00:00 | 299 | 2022-05-26 00:00:01 | 316 | 2022-05-27 00:00:02 | 328 | 2022-05-29 22:05:03 | 342 | 2022-05-30 00:00:01
12 | 2022-05-01 22:05:01 | 29 | 2022-05-02 00:00:00 | 54 | 2022-05-03 00:00:00 | 74 | 2022-05-04 00:00:01 | 96 | 2022-05-05 00:00:00 | 110 | 2022-05-06 00:00:01 |  |  |  |  |  |  |  |  | 155 | 2022-05-12 00:00:00 |  |  |  |  | 181 | 2022-05-16 00:00:01 | 193 | 2022-05-17 00:00:00 | 210 | 2022-05-18 00:00:01 | 229 | 2022-05-19 00:00:00 | 241 | 2022-05-20 00:00:01 | 254 | 2022-05-22 22:05:00 |  |  |  |  | 287 | 2022-05-25 00:00:01 | 300 | 2022-05-26 00:00:01 | 317 | 2022-05-27 00:00:02 | 329 | 2022-05-29 22:05:04 | 343 | 2022-05-30 00:00:01
13 | 2022-05-01 22:05:01 | 30 | 2022-05-02 00:00:00 | 55 | 2022-05-03 00:00:00 | 75 | 2022-05-04 00:00:01 | 97 | 2022-05-05 00:00:01 | 111 | 2022-05-06 00:00:01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 194 | 2022-05-17 00:00:00 | 211 | 2022-05-18 00:00:02 |  |  | 242 | 2022-05-20 00:00:01 | 255 | 2022-05-22 22:05:01 |  |  |  |  | 288 | 2022-05-25 00:00:01 | 301 | 2022-05-26 00:00:02 |  |  | 330 | 2022-05-29 22:05:04 | 344 | 2022-05-30 00:00:01
14 | 2022-05-01 22:05:01 | 31 | 2022-05-02 00:00:01 | 56 | 2022-05-03 00:00:01 | 76 | 2022-05-04 00:00:01 | 98 | 2022-05-05 00:00:01 | 112 | 2022-05-06 00:00:01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 195 | 2022-05-17 00:00:00 | 212 | 2022-05-18 00:00:02 |  |  |  |  | 256 | 2022-05-22 22:05:01 |  |  |  |  |  |  | 302 | 2022-05-26 00:00:02 |  |  | 331 | 2022-05-29 22:05:05 | 345 | 2022-05-30 00:00:01
15 | 2022-05-01 22:05:01 | 32 | 2022-05-02 00:00:01 | 57 | 2022-05-03 00:00:01 | 77 | 2022-05-04 00:00:02 |  |  | 113 | 2022-05-06 00:00:01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 196 | 2022-05-17 00:00:01 | 213 | 2022-05-18 00:00:02 |  |  |  |  | 257 | 2022-05-22 22:05:01 |  |  |  |  |  |  | 303 | 2022-05-26 00:00:02 |  |  |  |  | 346 | 2022-05-30 00:00:01
16 | 2022-05-01 22:05:01 | 33 | 2022-05-02 00:00:01 | 58 | 2022-05-03 00:00:01 | 78 | 2022-05-04 00:00:02 |  |  | 114 | 2022-05-06 00:00:01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 197 | 2022-05-17 00:00:01 | 214 | 2022-05-18 00:00:02 |  |  |  |  |  |  |  |  |  |  |  |  | 304 | 2022-05-26 00:00:02 |  |  |  |  | 347 | 2022-05-30 00:00:01
17 | 2022-05-01 22:05:01 | 34 | 2022-05-02 00:00:01 | 59 | 2022-05-03 00:00:01 | 79 | 2022-05-04 00:00:02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 198 | 2022-05-17 00:00:01 | 215 | 2022-05-18 00:00:02 |  |  |  |  |  |  |  |  |  |  |  |  | 305 | 2022-05-26 00:00:02
 |  | 35 | 2022-05-02 00:00:01 | 60 | 2022-05-03 00:00:01 | 80 | 2022-05-04 00:00:02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 216 | 2022-05-18 00:00:02
 |  | 36 | 2022-05-02 00:00:01 | 61 | 2022-05-03 00:00:01 | 81 | 2022-05-04 00:00:02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 217 | 2022-05-18 00:00:03
 |  | 37 | 2022-05-02 00:00:01 | 62 | 2022-05-03 00:00:01 | 82 | 2022-05-04 00:00:02
 |  | 38 | 2022-05-02 00:00:01 |  |  | 83 | 2022-05-04 00:00:02
 |  | 39 | 2022-05-02 00:00:02 |  |  | 84 | 2022-05-04 00:00:02
 |  | 40 | 2022-05-02 00:00:02
 |  | 41 | 2022-05-02 00:00:02
 |  | 42 | 2022-05-02 00:00:02
 |  |  |  |  |  |  |  | Expected Result |  |  | Starting Column No. for Range | Ending Column No. for Range
 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 4
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  | 52
 |  |  |  |  |  |  |  | 53
 |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  | 58
 |  |  |  |  |  |  |  | 59
 |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  | 62
 |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  | 66
 |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  | 68
 |  |  |  |  |  |  |  | 69
 |  |  |  |  |  |  |  | 70
 |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  | 72
 |  |  |  |  |  |  |  | 73
 |  |  |  |  |  |  |  | 74
 |  |  |  |  |  |  |  | 75
 |  |  |  |  |  |  |  | 76
 |  |  |  |  |  |  |  | 77
 |  |  |  |  |  |  |  | 78
 |  |  |  |  |  |  |  | 79
 |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  | 81
 |  |  |  |  |  |  |  | 82
 |  |  |  |  |  |  |  | 83
 |  |  |  |  |  |  |  | 84
 |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  | 86
 |  |  |  |  |  |  |  | 87
 |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  | 89
 |  |  |  |  |  |  |  | 90
 |  |  |  |  |  |  |  | 91
 |  |  |  |  |  |  |  | 92
 |  |  |  |  |  |  |  | 93
 |  |  |  |  |  |  |  | 94
 |  |  |  |  |  |  |  | 95
 |  |  |  |  |  |  |  | 96
 |  |  |  |  |  |  |  | 97
 |  |  |  |  |  |  |  | 98