Power Query Formula to Make Column Keep Retain Alphabetic When Refresh

hi all..

i have appended file when new refreshing data the column and rows is change
how to make formula in PQ so that in column C "KPKNL" automatic keep alphabetic sort.
here my attachment picture
any one help me, greatly appreciated

.susanto

Is that end result on the picture?
the A-Z sort of this column works for you?
anyway you can extract first letter after first space and sort it
maybe if you attach excel file with your example it will help more

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://eileenslounge.com/viewtopic.php?p=316254#p316254
https://eileenslounge.com/viewtopic.php?p=316280#p316280
https://eileenslounge.com/viewtopic.php?p=315915#p315915
https://eileenslounge.com/viewtopic.php?p=315512#p315512
https://eileenslounge.com/viewtopic.php?p=315744#p315744
https://www.eileenslounge.com/viewtopic.php?p=315512#p315512
https://eileenslounge.com/viewtopic.php?p=315680#p315680
https://eileenslounge.com/viewtopic.php?p=315743#p315743
https://www.eileenslounge.com/viewtopic.php?p=315326#p315326
https://www.eileenslounge.com/viewtopic.php?f=30&t=40752
https://eileenslounge.com/viewtopic.php?p=314950#p314950
https://www.eileenslounge.com/viewtopic.php?p=314940#p314940
https://www.eileenslounge.com/viewtopic.php?p=314926#p314926
https://www.eileenslounge.com/viewtopic.php?p=314920#p314920
https://www.eileenslounge.com/viewtopic.php?f=30&t=40533&p=314837#p314837
https://www.eileenslounge.com/viewtopic.php?f=21&t=40701&p=314836#p314836
https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314621#p314621
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

here attached file, my target in cell C2
yes, A-Z sort that's i want

that's all what I can do with your example
Attachment 3799

hi sandy666, thank you so much!!!

Quote:

---

Originally Posted by muhammad susanto

hi sandy666, thank you so much!!!

---

you are welcome

hi Sandy666,
i found new problem and to modified like this with the same example before it
how to way or make formula to sort "name of city (in col C)" with sort list like this below, start from first sort order
1. KPKNL Padang
2. KPKNL Bukittinggi
3. KPKNL Pekanbaru
4. KPKNL Batam
5. KPKNL Dumai

would you help me out?

hope it will help
Attachment 3801

hi sandy666, thanks again..

Quote:

---

Originally Posted by muhammad susanto

hi sandy666, thanks again..

---

no problem, hth