How to group part of a string and use it as filter....

[Nextstorm]

Lets say ...

I have a file with Productive lines thar are fragmented in several operations... lets say HI0XEmbo, HI0XCut, HI0XWrap, X goes from 1 to 10 Lines. But i want to group all to be HI01, HI02, HI03 and use it to filter the cost for each production line.

Any ideas?

Greets! 

[TomMartens · Accepted solution]

Hey @Nextstorm ,

In Power Query create a new column using the Extract/First characters transformation:

Hopefully this provides what you are looking for.

Regards,

Tom