Forum Discussion

Boycie92's avatar
Boycie92
Resolver I
8 years ago

Replace Values

Hi,

 

I was wondering if someone could help.

 

I know with power query you can mass replaces values. I was wondering if it was possible to do this for individual values?

 

For instance, I have 20 rows that and each have the letter A within a column. I would like to individually be able to alter them.

 

So that I can do something similar to this:

 

Row 1 A = A1

Row 2 A= A2

Row 3 A= A3

 

Thanks,

Boycie92

Need Help
Tips and Tricks

5 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi Boycie92,

     

    In Query Editor mode, please use the "Split Column" option twice. First time, split out A, second time, get a separate column listing row number.

     

    Then, combine these two columns.

    =[Column2]&Text.From([Column3])

     

    Best regards,
    Yuliana Gu

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      8 years ago

      Hi Boycie92,

       

      Have you achieved your desired result? If yes, would you please accept the helpful reply as an answer or share your solution?

       

      Best regards,
      Yuliana Gu

      • Boycie92's avatar
        Boycie92
        Resolver I
        8 years ago

        Hi v-yulgu-msft

         

        Apologies for the delay in responding.

         

        Your solution would work but within my column I have other values that I need to use. (A) Is just an example.

        So if I was to create another column I would need to somehow tell it if you see A show me A1 or A2 etc. However if the other values in the original column are not A the show me blank

         

        Now I could use a custom column to do this, the problem I have is telling it to split the A values?

         

        Thanks for the help,

        Boycie92