Transpose each value between delimiter into rows

[Heremion]

Hello, hello!

I'm a beginner in Power Query and I would like to know if someone could help me to resolve this problem please ?

I have the following data :

I would like to have, for each "clean_ano_4", a dedicated row.

For example for the line 6, I would like to have two lines : one with all the column of 6th line and a column with 432071, and a second with the same column but 432504 instead.

Like that :

200100	DSNCI	DSNCI_422836_Page DSN Entreprise ...	432071
200100	DSNCI	DSNCI_422836_Page DSN Entreprise ...	432504

Do you know if it's possible please ?

Thanks for your help and your time

H.

 

[RoryA]

Select the column , then choose Split Column, and make sure the delimiter is set to semicolon and that the advanced options are set to split to rows, not columns:

 

[Heremion]

Perfect!!!!! I didn't notice the advanced option and moreover the online transposition