Need Help

Hi Semaj06Fr 

Please try this:

Here's the sample table:

Click Transform data in the Home pane to use the power query:

Then add a custom column in the Add Column pane:

Text.Split([Raw Mat],"+")

Click Expand to new Rows:

Click Merge Queries in the Home pane:

Select the Custom column from the original table and Material column from the current table.

The result is as follow:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.