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...