I have data in Excel and my data contain below format:
Year | WeekNo
2024 | Week 1
2024 | Week 2
2024 | Week 3
.
.
.
2024 | Week 11
2024 | Week 12
2024 | Week 13
.
.
so on.
When I applied filter on WeekNo column the data looks like below format in Filter:
Week 1
Week 11
Week 12
Week 13
.
.
.
Week 19
Week 2
Week 20
Week 21
.
.
Week 29
Week 3
Week 31
Week 32
.
.
so on.
I want to see data in sequencial format in filter like : Week 1 Week 2 Week 3 . . Week 11 Week 12 Week 13 So on.
May I know, what shall I do to see the data in filter like this, please help me.
Thanks