Results 1 to 10 of 10

Thread: Power Query Formula to Make Column Keep Retain Alphabetic When Refresh

  1. #1
    Member
    Join Date
    Sep 2013
    Posts
    37
    Rep Power
    0

    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
    Attached Images Attached Images

  2. #2
    Sir Moderator sandy666's Avatar
    Join Date
    May 2018
    Posts
    236
    Rep Power
    7
    Last edited by DocAElstein; 04-16-2024 at 01:13 PM.
    sandy
    I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt

  3. #3
    Member
    Join Date
    Sep 2013
    Posts
    37
    Rep Power
    0
    here attached file, my target in cell C2
    yes, A-Z sort that's i want
    Attached Files Attached Files
    Last edited by muhammad susanto; 01-18-2022 at 02:20 PM.

  4. #4
    Sir Moderator sandy666's Avatar
    Join Date
    May 2018
    Posts
    236
    Rep Power
    7

    Cool

    that's all what I can do with your example
    sort alphabetic.xlsx
    sandy
    I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt

  5. #5
    Member
    Join Date
    Sep 2013
    Posts
    37
    Rep Power
    0
    hi sandy666, thank you so much!!!

  6. #6
    Sir Moderator sandy666's Avatar
    Join Date
    May 2018
    Posts
    236
    Rep Power
    7
    Quote Originally Posted by muhammad susanto View Post
    hi sandy666, thank you so much!!!
    you are welcome
    sandy
    I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt

  7. #7
    Member
    Join Date
    Sep 2013
    Posts
    37
    Rep Power
    0
    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?
    Last edited by muhammad susanto; 01-19-2022 at 09:24 AM.

  8. #8
    Sir Moderator sandy666's Avatar
    Join Date
    May 2018
    Posts
    236
    Rep Power
    7

    Cool

    hope it will help
    sort alphabetic.xlsx
    sandy
    I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt

  9. #9
    Member
    Join Date
    Sep 2013
    Posts
    37
    Rep Power
    0
    hi sandy666, thanks again..

  10. #10
    Sir Moderator sandy666's Avatar
    Join Date
    May 2018
    Posts
    236
    Rep Power
    7
    Quote Originally Posted by muhammad susanto View Post
    hi sandy666, thanks again..
    no problem, hth
    sandy
    I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt

Similar Threads

  1. PQ - Power Query split?
    By sandy666 in forum Power Query, Power Pivot and Power BI
    Replies: 1
    Last Post: 04-06-2021, 07:51 PM
  2. PQ - Power Query: search multiple columns against a list of values?
    By sandy666 in forum Power Query, Power Pivot and Power BI
    Replies: 0
    Last Post: 02-22-2021, 11:50 PM
  3. PQ - Transforming Text to Date in Power Query
    By sandy666 in forum Power Query, Power Pivot and Power BI
    Replies: 2
    Last Post: 02-22-2021, 01:08 AM
  4. PQ - How to get Total via Power Query
    By sandy666 in forum ETL PQ Tips and Tricks
    Replies: 0
    Last Post: 09-23-2020, 06:10 PM
  5. PQ - UnZip an use Content in Power Query
    By sandy666 in forum ETL PQ Tips and Tricks
    Replies: 0
    Last Post: 05-13-2020, 05:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •