Need Help

Hello everyone, I’m seeking assistance because I can’t seem to find a solution to my issue. I truly appreciate any time and help you can provide to address my request. Thank you in advance for your...

Anonymous
1 year ago
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.

Forum Discussion

Need Help