Spreadsheet: 683370d1592671164-formula-to-get-data-for-each-material-and-then-sort-the-data-according-to-start-date-store-2
Sheet: Report

 |  |  |  |  |  |  | Material | Material1 |  |  |  |  |  |  |  |  |  |  | Material | Material2
 |  |  | Material1 |  |  |  |  |  |  |  |  |  |  |  | Material2
 | [NAME] | Supplier | Material | Start Date | End Date |  | Floor-room | Supplier | Start_Date | End_Date |  |  | [NAME] | Supplier | Material | Start Date | End Date |  | Floor-room | Supplier | Start_Date | End_Date
 | 1-2 | Supplier2 | Material1 | 2019-10-05 00:00:00 | 2020-06-20 00:00:00 |  | 1-2 | Supplier2 | 2019-10-05 00:00:00 | 2020-06-20 00:00:00 |  |  | 2-5 | Supplier5 | Material2 | 2020-05-08 00:00:00 | 2020-06-20 00:00:00 |  | 2-6 | Supplier6 | 2020-05-08 00:00:00 | 2020-06-20 00:00:00
 | 1-3 | Supplier2 | Material1 | 2019-10-10 00:00:00 | 2020-06-20 00:00:00 |  | 1-3 | Supplier2 | 2019-10-10 00:00:00 | 2020-06-20 00:00:00 |  |  | 2-6 | Supplier6 | Material2 | 2020-05-08 00:00:00 | 2020-06-20 00:00:00 |  | 2-5 | Supplier5 | 2020-05-08 00:00:00 | 2020-06-20 00:00:00
 | 2-3 | Supplier4 | Material1 | 2019-10-12 00:00:00 | 2020-06-20 00:00:00 |  | 2-3 | Supplier4 | 2019-10-12 00:00:00 | 2020-06-20 00:00:00 |  |  | 4-4 | Supplier9 | Material2 | 2020-05-09 00:00:00 | 2020-06-20 00:00:00 |  | 4-4 | Supplier9 | 2020-05-09 00:00:00 | 2020-06-20 00:00:00
 | 2-4 | Supplier1 | Material1 | 2019-10-19 00:00:00 | 2020-06-20 00:00:00 |  | 2-4 | Supplier1 | 2019-10-19 00:00:00 | 2020-06-20 00:00:00 |  |  | 4-2 | Supplier6 | Material2 | 2020-05-13 00:00:00 | 2020-06-20 00:00:00 |  | 4-2 | Supplier6 | 2020-05-13 00:00:00 | 2020-06-20 00:00:00
 | 1-4 | Supplier1 | Material1 | 2020-01-24 00:00:00 | 2020-06-20 00:00:00 |  | 1-4 | Supplier1 | 2020-01-24 00:00:00 | 2020-06-20 00:00:00 |  |  | 4-6 | Supplier10 | Material2 | 2020-05-13 00:00:00 | 2020-06-20 00:00:00 |  | 4-6 | Supplier10 | 2020-05-13 00:00:00 | 2020-06-20 00:00:00
 | 1-5 | Supplier1 | Material1 | 2020-06-02 00:00:00 | 2020-06-20 00:00:00 |  | 1-5 | Supplier1 | 2020-06-02 00:00:00 | 2020-06-20 00:00:00 |  |  | 4-3 | Supplier9 | Material2 | 2020-05-15 00:00:00 | 2020-06-20 00:00:00 |  | 4-3 | Supplier9 | 2020-05-15 00:00:00 | 2020-06-20 00:00:00
 | 2-7 | Supplier7 | Material1 | 2020-06-06 00:00:00 | 2020-06-20 00:00:00 |  | 2-7 | Supplier7 | 2020-06-06 00:00:00 | 2020-06-20 00:00:00 |  |  | 4-1 | Supplier8 | Material2 | 2020-05-19 00:00:00 | 2020-06-20 00:00:00 |  | 4-1 | Supplier8 | 2020-05-19 00:00:00 | 2020-06-20 00:00:00
 | 1-1 | Supplier1 | Material1 | 2020-06-07 00:00:00 | 2020-06-20 00:00:00 |  | 1-1 | Supplier1 | 2020-06-07 00:00:00 | 2020-06-20 00:00:00
 |  |  |  |  |  |  | Material | RDF |  |  |  |  |  |  |  |  |  |  | Material | Material4
 |  |  | Material3 |  |  |  |  |  |  |  |  |  |  |  | Material4
 | [NAME] | Supplier | Material | Start Date | End Date |  | Floor-room | Supplier | Start_Date | End_Date |  |  | [NAME] | Supplier | Material | Start Date | End Date |  | Floor-room | Supplier | Start_Date | End_Date
 | 8-1 | Supplier17 | Material3 | 2019-09-01 00:00:00 | 2020-06-20 00:00:00 |  | 8-1 | Supplier17 | 2019-09-01 00:00:00 | 2020-06-20 00:00:00 |  |  | 1-6 | Supplier3 | Material4 | 2020-05-22 00:00:00 | 2020-06-20 00:00:00 |  | 3-1 | Supplier3 | 2018-10-16 00:00:00 | 2020-06-20 00:00:00
 | 9-1 | Supplier17 | Material3 | 2019-09-01 00:00:00 | 2020-06-20 00:00:00 |  | 9-1 | Supplier17 | 2019-09-01 00:00:00 | 2020-06-20 00:00:00 |  |  | 3-1 | Supplier3 | Material4 | 2018-10-16 00:00:00 | 2020-06-20 00:00:00 |  | 3-2 | Supplier3 | 2018-12-15 00:00:00 | 2020-06-20 00:00:00
 | 9-2 | Supplier17 | Material3 | 2019-09-02 00:00:00 | 2020-06-20 00:00:00 |  | 9-2 | Supplier17 | 2019-09-02 00:00:00 | 2020-06-20 00:00:00 |  |  | 3-2 | Supplier3 | Material4 | 2018-12-15 00:00:00 | 2020-06-20 00:00:00 |  | 3-3 | Supplier3 | 2019-02-15 00:00:00 | 2020-06-20 00:00:00
 | 8-2 | Supplier19 | Material3 | 2019-09-04 00:00:00 | 2020-06-20 00:00:00 |  | 8-2 | Supplier19 | 2019-09-04 00:00:00 | 2020-06-20 00:00:00 |  |  | 3-3 | Supplier3 | Material4 | 2019-02-15 00:00:00 | 2020-06-20 00:00:00 |  | 3-4 | Supplier3 | 2019-04-15 00:00:00 | 2020-06-20 00:00:00
 | 7-3 | Supplier18 | Material3 | 2019-09-06 00:00:00 | 2020-06-20 00:00:00 |  | 7-4 | Supplier11 | 2019-09-06 00:00:00 | 2020-06-20 00:00:00 |  |  | 3-4 | Supplier3 | Material4 | 2019-04-15 00:00:00 | 2020-06-20 00:00:00 |  | 3-5 | Supplier3 | 2019-08-15 00:00:00 | 2020-06-20 00:00:00
 | 7-4 | Supplier11 | Material3 | 2019-09-06 00:00:00 | 2020-06-20 00:00:00 |  | 7-3 | Supplier18 | 2019-09-06 00:00:00 | 2020-06-20 00:00:00 |  |  | 3-5 | Supplier3 | Material4 | 2019-08-15 00:00:00 | 2020-06-20 00:00:00 |  | 1-6 | Supplier3 | 2020-05-22 00:00:00 | 2020-06-20 00:00:00
 | 7-5 | Supplier11 | Material3 | 2019-09-06 00:00:00 | 2020-06-20 00:00:00 |  | 7-5 | Supplier11 | 2019-09-06 00:00:00 | 2020-06-20 00:00:00
 | 10-3 | Supplier11 | Material3 | 2019-09-06 00:00:00 | 2020-06-20 00:00:00 |  | 10-3 | Supplier11 | 2019-09-06 00:00:00 | 2020-06-20 00:00:00
 | 7-2 | Supplier17 | Material3 | 2019-09-12 00:00:00 | 2020-06-20 00:00:00 |  | 7-2 | Supplier17 | 2019-09-12 00:00:00 | 2020-06-20 00:00:00
 | 8-4 | Supplier16 | Material3 | 2019-09-17 00:00:00 | 2020-06-20 00:00:00 |  | 8-4 | Supplier16 | 2019-09-17 00:00:00 | 2020-06-20 00:00:00
 | 7-1 | Supplier17 | Material3 | 2019-09-20 00:00:00 | 2020-06-20 00:00:00 |  | 7-1 | Supplier17 | 2019-09-20 00:00:00 | 2020-06-20 00:00:00
 | 6-3 | Supplier15 | Material3 | 2019-10-06 00:00:00 | 2020-06-20 00:00:00 |  | 6-3 | Supplier15 | 2019-10-06 00:00:00 | 2020-06-20 00:00:00
 | 6-4 | Supplier16 | Material3 | 2019-10-22 00:00:00 | 2020-06-20 00:00:00 |  | 6-4 | Supplier16 | 2019-10-22 00:00:00 | 2020-06-20 00:00:00
 | 10-1 | Supplier14 | Material3 | 2019-10-22 00:00:00 | 2020-06-20 00:00:00 |  | 10-1 | Supplier14 | 2019-10-22 00:00:00 | 2020-06-20 00:00:00
 | 10-4 | Supplier6 | Material3 | 2019-11-20 00:00:00 | 2020-06-20 00:00:00 |  | 10-6 | Supplier6 | 2019-11-20 00:00:00 | 2020-06-20 00:00:00
 | 10-5 | Supplier6 | Material3 | 2019-11-20 00:00:00 | 2020-06-20 00:00:00 |  | 10-4 | Supplier6 | 2019-11-20 00:00:00 | 2020-06-20 00:00:00
 | 10-6 | Supplier6 | Material3 | 2019-11-20 00:00:00 | 2020-06-20 00:00:00 |  | 10-5 | Supplier6 | 2019-11-20 00:00:00 | 2020-06-20 00:00:00
 | 6-1 | Supplier13 | Material3 | 2019-11-21 00:00:00 | 2020-06-20 00:00:00 |  | 6-1 | Supplier13 | 2019-11-21 00:00:00 | 2020-06-20 00:00:00
 | 9-4 | Supplier8 | Material3 | 2020-01-15 00:00:00 | 2020-06-20 00:00:00 |  | 9-7 | Supplier8 | 2020-01-15 00:00:00 | 2020-06-20 00:00:00
 | 9-6 | Supplier8 | Material3 | 2020-01-15 00:00:00 | 2020-06-20 00:00:00 |  | 10-2 | Supplier12 | 2020-01-15 00:00:00 | 2020-06-20 00:00:00
 | 9-7 | Supplier8 | Material3 | 2020-01-15 00:00:00 | 2020-06-20 00:00:00 |  | 9-6 | Supplier8 | 2020-01-15 00:00:00 | 2020-06-20 00:00:00
 | 10-2 | Supplier12 | Material3 | 2020-01-15 00:00:00 | 2020-06-20 00:00:00 |  | 9-4 | Supplier8 | 2020-01-15 00:00:00 | 2020-06-20 00:00:00
 | 9-3 | Supplier21 | Material3 | 2020-03-11 00:00:00 | 2020-06-20 00:00:00 |  | 9-3 | Supplier21 | 2020-03-11 00:00:00 | 2020-06-20 00:00:00
 | 9-5 | Supplier21 | Material3 | 2020-03-11 00:00:00 | 2020-06-20 00:00:00 |  | 9-5 | Supplier21 | 2020-03-11 00:00:00 | 2020-06-20 00:00:00
 | 5-1 | Supplier11 | Material3 | 2020-05-15 00:00:00 | 2020-06-20 00:00:00 |  | 5-2 | Supplier12 | 2020-05-15 00:00:00 | 2020-06-20 00:00:00
 | 5-2 | Supplier12 | Material3 | 2020-05-15 00:00:00 | 2020-06-20 00:00:00 |  | 5-3 | Supplier6 | 2020-05-15 00:00:00 | 2020-06-20 00:00:00
 | 5-3 | Supplier6 | Material3 | 2020-05-15 00:00:00 | 2020-06-20 00:00:00 |  | 6-5 | Supplier6 | 2020-05-15 00:00:00 | 2020-06-20 00:00:00
 | 6-5 | Supplier6 | Material3 | 2020-05-15 00:00:00 | 2020-06-20 00:00:00 |  | 5-1 | Supplier11 | 2020-05-15 00:00:00 | 2020-06-20 00:00:00
 | 8-3 | Supplier20 | Material3 | 2020-06-07 00:00:00 | 2020-06-20 00:00:00 |  | 8-3 | Supplier20 | 2020-06-07 00:00:00 | 2020-06-20 00:00:00
 | 6-2 | Supplier14 | Material3 | 2020-06-13 00:00:00 | 2020-06-20 00:00:00 |  | 6-2 | Supplier14 | 2020-06-13 00:00:00 | 2020-06-20 00:00:00