Need help, one customer variety of names

[AZ17]

Hi All,

Thank you for looking at my case.

Here is the problem:

I have a this column in my powerbi (the names of the customers are not real, they are examples):

And this is what I would like to achieve: 

In my actual file there is about 200 customers with variety of names and they change depending on the month and settings of the file. 

Any clue how to do this? (I would like to avoid using R as I have no knowledge of it)

Thank you for your help and thoughts!

Kr, 

A

[Greg_Deckler · Accepted solution]

@AZ17 Well, from the examples given, do a split based upon spaces and remove the extraneous columns. Or you can use the Text parsing functions to do the same. Text.PositionOfAny and Text.Start.

[AZ17]

Hi Greg, thank you for providing a solution, I have made some changes and it seems to fit the purpose!

Thank you for your assistance, have a great day.