Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 🙂
Solved! Go to Solution.
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.
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.
Hi @Spotto
You can split your column in rows with the advanced options of split column:
and you get what you want exactly
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
69 | |
69 | |
24 | |
18 | |
13 |