Forum Discussion
Aladdin_Ajaj
Dec 25, 2022Copper Contributor
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
- sivakumarrjBrass ContributorUse filter function for excel 365 otherwise use if with index match.