Spreadsheet: 683366d1592667159-formula-to-get-data-for-each-material-and-then-sort-the-data-according-to-start-date-store
Sheet: Data

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