Forum Discussion
Helper IVSeparate two or more codes on the same line into two or more lines
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 🙂
Hi Spotto
You can split your column in rows with the advanced options of split column:
and you get what you want exactly
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.
2 Replies
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-msftCommunity Support
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.