Need Help

[Semaj06Fr]

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 support!

Here are my data. For each material, I have its description and the name of its component.

Material	Description	Raw Mat
A	Product A	B
B	Product B	AA
C	Product C	D+E
E	Product E	BB

What I would like to achieve is the following result: When I select a finished product, it gives me the details of the operations to perform and the components to use. I would like a table like the one below:

Material	Description	Raw Mat	RM Des	RM Raw Mat
A	Product A	B	Product B	AA
C	Product C	D		Raw Mat
C	Product C	E	Product B	BB

[Anonymous · Accepted solution]

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.

[JamesFR06]

Hello. Just to follow