Spreadsheet: 690280d1596997611-grid-to-list-formula-grid-to-list-formula-v2
Sheet: EXAMPLE

[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DESIRED OUTPUT
SKU | UPC | [NAME] | FINISH | DLR NET | MAP | MSRP |  | 2020-01-10 00:00:00 | 2020-02-10 00:00:00 | 2020-03-10 00:00:00 | 2020-04-10 00:00:00 | 2020-05-10 00:00:00 | 2020-06-10 00:00:00 | 2020-07-10 00:00:00 | 2020-08-10 00:00:00 | 2020-09-10 00:00:00 | 2020-10-10 00:00:00 | 2020-11-10 00:00:00 | 2020-12-10 00:00:00 |  | SKU | QUANTITY | DATE |  |  | SKU | QUANTITY | DATE
A | 1 | [NAME] | FINISH | 1 | 2 | 3 | X |  |  |  |  |  |  |  | 1 |  | 3 | 4 | 5 |  |  |  |  |  |  | A | 1 | 2020-08-10 00:00:00
B | 2 | [NAME] | FINISH | 1 | 2 | 3 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | A | 3 | 2020-10-10 00:00:00
C | 3 | [NAME] | FINISH | 1 | 2 | 3 |  |  |  |  |  |  |  |  | 5 | 4 |  | 2 | 1 |  |  |  |  |  |  | A | 4 | 2020-11-10 00:00:00
D | 4 | [NAME] | FINISH | 1 | 2 | 3 |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  |  |  |  |  | A | 5 | 2020-12-10 00:00:00
E | 5 | [NAME] | FINISH | 1 | 2 | 3 | X |  |  |  |  |  |  |  |  | 3 |  | 1 |  |  |  |  |  |  |  | B | 1 | 2020-08-10 00:00:00
F | 6 | [NAME] | FINISH | 1 | 2 | 3 |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 |  |  |  |  |  |  | C | 5 | 2020-08-10 00:00:00
G | 7 | [NAME] | FINISH | 1 | 2 | 3 |  |  |  |  |  |  |  |  | 1 |  | 5 |  |  |  |  |  |  |  |  | C | 4 | 2020-09-10 00:00:00
H | 8 | [NAME] | FINISH | 1 | 2 | 3 | X |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  | C | 2 | 2020-11-10 00:00:00
I | 9 | [NAME] | FINISH | 1 | 2 | 3 |  |  |  |  |  |  |  |  |  | 2 |  | 1 |  |  |  |  |  |  |  | C | 1 | 2020-12-10 00:00:00
J | 10 | [NAME] | FINISH | 1 | 2 | 3 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | D | 1 | 2020-10-10 00:00:00
K | 11 | [NAME] | FINISH | 1 | 2 | 3 |  |  |  |  |  |  |  |  |  |  | 2 |  | 3 |  |  |  |  |  |  | D | 1 | 2020-12-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | 3 | 2020-09-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | 1 | 2020-11-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 1 | 2020-09-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 1 | 2020-10-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 1 | 2020-12-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G | 1 | 2020-08-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G | 5 | 2020-10-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | 2 | 2020-12-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I | 2 | 2020-09-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I | 1 | 2020-11-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | 1 | 2020-11-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K | 2 | 2020-10-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K | 3 | 2020-12-10 00:00:00