I am using excel and it's power query editor and I am trying to replace multiple different values into one new value. For instance I want to turn values such as 2/1/2018 0:00, 2/2/2018 0:00, 2/4/2018 0:00, and 2/10/2018 0:00 into February 2018. I need to do this for hundreds to thousands of different values so I don't want to just use the replace values command in the Transform tab, If someone can tell me how to change a range of values into one value in the power query editor that may help. I also want to in the power query editor to be able to get rid of duplicate values of still leave empty cells of the values that were duplicated,

for instance I want to turn "AB" "123" "one" "AB" "123" "one.5" "AB" "234"" two" "AB" "345" "three" "AB" "345" "three.5" "AB" "345" "three.6"

Into

"AB" "123" "one" " " " " "one.5" " " "234"" two" " " "345" "three" " " " " "three.5" " " " " "three.6". The quotations were to help differentiate each column to whoever is reading this. Essentially I just need these two questions solved, By the way the programming language for power query editor is "M". Any help to solve this would be appreciated. The advanced query editor may be of help to solve this.

I need these solved in the power query editor because the power query table will be refreshed every few days so new data will be pulled into the table so I need these changes in power query so they stay permanent as new data is collected.