Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Edit Single Cell using power Query

I am trying to edit the data (individual cells)through Power query. I need a forumla to convert the table below . for example Input                                                           1...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous 

     

    Another way could be to use this custom column

     

    =Text.Select([Column1],{"a".."z"}&{"A".."Z"})

EugenioJunior's avatar
EugenioJunior
Frequent Visitor
7 years ago

Hi, Anonymous 

Try 

Column = 
IF(table[column] = "1. Toyota", "Toyota",
IF(table[column] = "2. Ford", "Ford",
IF(table[column] = "3. Nissan", "Nissan",
IF(table[column] = "4. Fiat", "Fiat", table[column] ))))
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Anonymous 

     

    Another way could be to use this custom column

     

    =Text.Select([Column1],{"a".."z"}&{"A".."Z"})