Spreadsheet: 683385d1592681060-formula-to-get-data-for-each-material-and-then-sort-the-data-according-to-start-date-store
Sheet: Sheet1

[NAME] | Floor | Room | Supplier | Material | Start Date | End Date
2-3 | 2 | 3 | Supplier4 | Material1 | 2019-10-12 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
2-7 | 2 | 7 | Supplier7 | Material1 | 2020-06-06 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
1-2 | 1 | 2 | Supplier2 | Material1 | 2019-10-05 00:00:00 | 2020-06-20 00:00:00
1-1 | 1 | 1 | Supplier1 | Material1 | 2020-06-07 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
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-6 | 4 | 6 | Supplier10 | Material2 | 2020-05-13 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-3 | 4 | 3 | Supplier9 | Material2 | 2020-05-15 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-5 | 2 | 5 | Supplier5 | Material2 | 2020-05-08 00:00:00 | 2020-06-20 00:00:00
3-1 | 3 | 1 | Supplier3 | Material4 | 2018-10-16 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
3-4 | 3 | 4 | Supplier3 | Material4 | 2019-04-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-2 | 3 | 2 | Supplier3 | Material4 | 2018-12-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
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-2 | 9 | 2 | Supplier17 | RDF | 2019-09-02 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
9-1 | 9 | 1 | Supplier17 | RDF | 2019-09-01 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
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-3 | 10 | 3 | Supplier11 | RDF | 2019-09-06 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
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
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-1 | 6 | 1 | Supplier13 | RDF | 2019-11-21 00:00:00 | 2020-06-20 00:00:00
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
6-5 | 6 | 5 | Supplier6 | RDF | 2020-05-15 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
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
7-4 | 7 | 4 | Supplier11 | RDF | 2019-09-06 00:00:00 | 2020-06-20 00:00:00
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