Forum Discussion

Aladdin_Ajaj's avatar
Aladdin_Ajaj
Copper Contributor
Dec 25, 2022

How to get certain region from region columns and inserted in new columns as others

I have certain regions in excel table I have managed to get data from top regions using add conditional columns in power query "if region equal x then insert x value'' and so on I got 80% of the data and for the rest regions I want to combine them as others. 

 

The formula I want to achieve is (If Region equal x region or x region or x region then don't return there values instead return me the values from list I choose from the table  )

 

note: each region associate with certain row data I want to extract and separate them into certain columns

 

   

  • sivakumarrj's avatar
    sivakumarrj
    Brass Contributor
    Use filter function for excel 365 otherwise use if with index match.

Resources