Generate Rows conditional on cells

maxiemens

Hi guys I want to generate rows conditional from a cell (Material):

from this:

to this:

any ideas?

I would appreciate that 🙂 

Thanks 

grossal

Hi @maxiemens,

you can easily do this with the Text-To-Columns Tool:

Result:

Setting:

Let me know if this helps 😃

Best

Alex

PS: You are currently in the German Forum, feel free to speak German 😉