Tigerexcel
Active Member
- Joined
- Mar 6, 2020
- Messages
- 493
- Office Version
- 365
- 2019
- Platform
- Windows
I'm trying to sort this trimester based information. The desired output is in the second table, ie Tri 1 2017, Tri 2 2017, Tri 3 2017 etc, in other words chronological order. Even with a custom sort I cannot get the result on the right.
Book10 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Period | Subject | Period | Subject | |||
2 | Tri 1 2017 | French | Tri 1 2017 | Maths | |||
3 | Tri 1 2017 | Maths | Tri 2 2017 | Geog | |||
4 | Tri 2 2017 | English | Tri 3 2017 | Hist | |||
5 | Tri 2 2017 | Geog | Tri 1 2018 | French | |||
6 | Tri 3 2017 | Hist | Tri 2 2018 | English | |||
7 | Tri 3 2017 | Science | Tri 3 2018 | Science | |||
8 | Tri 1 2018 | French | Tri 1 2019 | Maths | |||
9 | Tri 1 2018 | Maths | Tri 2 2019 | Geog | |||
10 | Tri 2 2018 | English | Tri 3 2019 | Hist | |||
11 | Tri 2 2018 | Geog | Tri 1 2017 | French | |||
12 | Tri 3 2018 | Hist | Tri 2 2017 | English | |||
13 | Tri 3 2018 | Science | Tri 3 2017 | Science | |||
14 | Tri 1 2019 | French | Tri 1 2018 | Maths | |||
15 | Tri 1 2019 | Maths | Tri 2 2018 | Geog | |||
16 | Tri 2 2019 | English | Tri 3 2018 | Hist | |||
17 | Tri 2 2019 | Geog | Tri 1 2019 | French | |||
18 | Tri 3 2019 | Hist | Tri 2 2019 | English | |||
19 | Tri 3 2019 | Science | Tri 3 2019 | Science | |||
Sheet1 |