Spreadsheet: 706874d1606931918-look-up-table-and-transpose-to-another-excel-help
Sheet: Sheet1

 | ID | Category D | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | ID | Blank | Date | Category A | Category B | Category C | Category D
 | 301 | Name A | 462 | 464 | 469 | 471 | 476 | 483 | 491 | 486 | 480 | 475 | 463 | 455 |  | 301 |  | 2021-01-01 00:00:00 |  | 24 | 824 | 462
 | 302 | Name B | 436 | 439 | 438 | 436 | 444 | 451 | 461 | 457 | 457 | 452 | 456 | 450 |  | 301 |  | 2021-02-01 00:00:00 |  | 21 | 824 | 464
 | 303 | Name C | 294 | 300 | 305 | 305 | 313 | 322 | 322 | 314 | 311 | 310 | 316 | 313 |  | 301 |  | 2021-03-01 00:00:00 |  | 22 | 824 | 469
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 301 |  | 2021-04-01 00:00:00 |  | 24 | 824 | 471
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 301 |  | 2021-05-01 00:00:00 |  | 25 | 824 | 476
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 301 |  | 2021-06-01 00:00:00 |  | 22 | 824 | 483
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 301 |  | 2021-07-01 00:00:00 |  | 8 | 824 | 491
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 301 |  | 2021-08-01 00:00:00 |  | 46 | 824 | 486
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 301 |  | 2021-09-01 00:00:00 |  | 35 | 824 | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 301 |  | 2021-10-01 00:00:00 |  | 29 | 824 | 475
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 301 |  | 2021-11-01 00:00:00 |  | 45 | 824 | 463
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 301 |  | 2021-12-01 00:00:00 |  | 23 | 824 | 455
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 302 |  | 2021-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 302 |  | 2021-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 302 |  | 2021-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 302 |  | 2021-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 302 |  | 2021-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 302 |  | 2021-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 302 |  | 2021-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 302 |  | 2021-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 302 |  | 2021-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 302 |  | 2021-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 302 |  | 2021-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 302 |  | 2021-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 303 |  | 2021-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 303 |  | 2021-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 303 |  | 2021-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 303 |  | 2021-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 303 |  | 2021-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 303 |  | 2021-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 303 |  | 2021-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 303 |  | 2021-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 303 |  | 2021-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 303 |  | 2021-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 303 |  | 2021-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 303 |  | 2021-12-01 00:00:00