Forum Discussion
Spotto
Helper IV
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 VOUCHE...
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.
v-yalanwu-msft
Community Support
Community SupportHi, 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.