Hello,

I would like to arrange this table so it shows the Material with the earliest date first, but all lines for this specific Materiel. Then the next earliest Material and all lines for this Material.

TABLE BEFORE ARRANGING
Schedule Date Material
01-01-2022 ABC
01-01-2022 ABC
01-01-2022 ABC
01-01-2022 ABC
01-02-2022 ABC
01-02-2022 A123
01-02-2022 A123
01-02-2022 A123
01-03-2022 ABC
01-03-2022 ABC
01-03-2022 A123
01-03-2022 A123
01-03-2022 A123

TABLE AFTER ARRANGING:
Schedule Date Material
01-01-2022 ABC
01-01-2022 ABC
01-01-2022 ABC
01-01-2022 ABC
01-02-2022 ABC
01-03-2022 ABC
01-03-2022 ABC
01-02-2022 A123
01-02-2022 A123
01-02-2022 A123
01-03-2022 A123
01-03-2022 A123
01-03-2022 A123

Is there anyway to do this in Excel? I hope it makes sense.

Thanks in advance,

BR,
Mads