snake single column into multiple columns right to left and left to right

Hi!

I have an Excel with one column with 637 values. I would like to organize them into w table with 13 columns and 49 rows in a snake mode Left & Up: Start on the bottom right and go up line by linas, as follows:

637 636 635 634 633 632 631 630 629 628 627 626 625
612 613 614 615 616 617 618 619 620 621 622 623 624
611 610 609 608 607 606 605 604 603 602 601 600 599
586 587 588 589 590 591 592 593 594 595 596 597 598
585 584 583 582 581 580 579 578 576 575 574 573 572
559 560 561 562 563 564 565 566 567 568 569 570 571
558 557 556 555 554 553 552 551 550 549 548 547 546
533 534 535 536 537 538 539 540 541 542 543 544 545
532 531 530 529 528 527 526 525 524 523 522 521 520
507 508 509 510 511 512 513 514 515 516 517 518 519
506 505 504 503 502 501 500 499 498 497 496 495 494
481 482 483 484 485 486 487 488 489 490 491 492 493
480 479 478 477 476 475 474 473 472 471 470 469 468
455 456 457 458 459 460 461 462 463 464 465 466 467
454 453 452 451 450 449 448 447 446 445 444 443 442
429 430 431 432 433 434 435 436 437 438 439 440 441
428 427 426 425 424 423 422 421 420 419 418 417 416
403 404 405 406 407 408 409 410 411 412 413 414 415
402 401 400 398 397 396 395 394 393 392 391 390 389
369 370 371 372 393 394 395 383 384 385 386 387 388
368 367 366 365 364 363 362 361 360 359 358 357 356
354 355 354 353 352 351 350 349 348 347 346 345 344
353 352 351 350 349 348 347 346 345 343 342 341 340
327 328 329 330 331 332 333 334 335 336 337 338 339
326 325 324 323 322 321 320 319 318 317 316 315 314
301 302 303 304 305 306 307 308 309 310 311 312 313
300 299 298 297 296 295 294 293 292 291 290 289 288
275 276 277 278 279 280 281 282 283 284 285 286 287
274 273 272 271 270 269 268 267 266 265 264 263 262
249 250 251 252 253 254 255 256 257 258 259 260 261
248 247 246 245 244 243 242 241 240 239 238 237 236
223 224 225 226 227 228 229 230 231 232 233 234 235
222 221 220 219 218 217 216 215 214 213 212 211 210
197 198 199 200 201 202 203 204 205 206 207 208 209
196 195 194 193 192 191 190 189 188 187 186 185 184
171 172 173 174 175 176 177 178 179 180 181 182 183
170 169 168 167 166 165 164 163 162 161 160 159 158
145 146 147 148 149 150 151 152 153 154 155 156 157
144 143 142 141 140 139 138 137 136 135 134 133 132
119 120 121 122 123 124 125 126 127 128 129 130 131
118 117 116 115 114 113 112 111 110 109 108 107 106
93 94 95 96 97 98 99 100 101 102 103 104 105
92 91 90 89 88 87 86 85 84 83 82 81 80
67 68 69 70 71 72 73 74 75 76 77 78 79
66 64 63 62 61 60 59 58 57 56 55 54 53
40 41 42 43 44 45 46 47 48 49 50 51 52
39 38 37 36 35 34 33 32 31 30 29 28 27
14 15 16 17 18 19 20 21 22 23 24 25 26
13 12 11 10 9 8 7 6 5 4 3 2 1

Can anyone help?
Thanks a lot

So "1" is first value in your list or last?

Yes, 1 is the firts value.

See attached

in C1

=IF(MOD(ROWS($1:1),2),INDEX($A$1:$A$637,(50-ROWS($1:1))*13-COLUMNS($B$1:B$1)+1),INDEX($A$1:$A$637,(49-ROWS($1:1))*13+COLUMNS($B$1:B$1)))

that's it! amazing job! thanks a lot!!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.