Spreadsheet: 732871d1621278445-index-match-to-return-transposed-array-values-excel-forums-example-for-searching-and-transposing-data
Sheet: Sheet1

Subcategory |  | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 |  | SubCategory | Transposed
AAA | F | G | H | I | J | K | L | M | N | O | P | Q |  | AAA |  |  |  |  |  | F
BBB | A | G | F | I | J | @ | S | M | N | O | P | Q |  | AAA | G |  |  |  | AAA | G
CCC | F | 32 | H | 512 | J | K | L | 123 | N | O | 2 | Q |  | AAA | H |  |  |  | AAA | H
DDD | F | G | H | 3 | J | K | L | M | 3 | O | P | Q |  | AAA | I |  |  |  | AAA | I
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA | J |  |  |  | AAA | J
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA | K |  |  |  | AAA | K
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA | L |  |  |  | AAA | L
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA | M |  |  |  | AAA | M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA | N |  |  |  | AAA | N
 |  |  |  |  |  | What I Have: |  |  |  |  |  |  |  | AAA | O |  |  |  | AAA | O
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA | P |  |  |  | AAA | P
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA | Q |  |  |  | AAA | Q
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB |  |  |  |  | BBB | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB | G |  |  |  | BBB | G
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB | F |  |  |  | BBB | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB | I |  |  |  | BBB | I
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB | J |  |  |  | BBB | J
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB | @ |  |  |  | BBB | @
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB | S |  |  |  | BBB | S
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB | M |  |  |  | BBB | M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB | N |  |  |  | BBB | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB | O |  |  |  | BBB | O
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB | P |  |  |  | BBB | P
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB | Q |  |  | What I Want: | BBB | Q
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC |  |  |  |  | CCC | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC | 32 |  |  |  | CCC | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC | H |  |  |  | CCC | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC | 512 |  |  |  | CCC | 512
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC | J |  |  |  | CCC | J
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC | K |  |  |  | CCC | K
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC | L |  |  |  | CCC | L
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC | 123 |  |  |  | CCC | 123
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC | N |  |  |  | CCC | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC | O |  |  |  | CCC | O
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC | 2 |  |  |  | CCC | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC | Q |  |  |  | CCC | Q
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DDD |  |  |  |  | DDD | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DDD | G |  |  |  | DDD | G
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DDD | H |  |  |  | DDD | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DDD | 3 |  |  |  | DDD | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DDD | J |  |  |  | DDD | J
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DDD | K |  |  |  | DDD | K
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DDD | L |  |  |  | DDD | L
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DDD | M |  |  |  | DDD | M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DDD | 3 |  |  |  | DDD | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DDD | O |  |  |  | DDD | O
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DDD | P |  |  |  | DDD | P
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DDD | Q |  |  |  | DDD | Q