Separate two or more codes on the same line into two or more lines

[Spotto]

Hi everyone, I need some help.
I have a table in excel that has a column (VOUCHER) where there are two codes separated by (-), I would like to know how to do it in power query to separate the VOUCHER into two or more lines and repeat the other information from the other columns

Example 1)

CODE	TIPE	VOUCHER
287865	X1	1955734 - 1955745

RESULT

CODE	TIPE	VOUCHER
287865	X1	1955734
287865	X1	1955745

Example 2)

CODE	TIPE	VOUCHER
123456	X1	1955734 - 1955745 - 1957865

RESULT

CODE	TIPE	VOUCHER
123456	X1	1955734
123456	X1	1955745
123456	X1	1957865

tks for helpe me 🙂

[Anonymous · Accepted solution]

Hi @Spotto 

You can split your column in rows with the advanced options of split column:

and you get what you want exactly

[v-yalanwu-msft · Accepted solution]

Hi, @Spotto ;

You could split the column by "-".

Then unpivot those columns.

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @Spotto 

You can split your column in rows with the advanced options of split column:

and you get what you want exactly