seprate numbers

[Talal141218]

Hello together, 

I am new with power Bi and want to put each customer reference in new row. As you see there is more than number in each row. 

Thanks in advance 

[Talal141218]

Thanks a lot 

[amitchandak · Accepted solution]

@Talal141218 , Power Query split by delimiter

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag

or

Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c