Forum Discussion
Create multiple columns from rows
Hi Anonymous ,
Here are the steps you can follow：
1. In power query – select [schema] – Spliy Column – By Delimiter.
Split at : Left – most delimiter.
2. Select [schema.2] – Transform – Pivot Column.
Values Column – [Flag]
Aggreate Value Function – Don’t Aggregate
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous ,
Here are the steps you can follow：
1. In power query – select [schema] – Spliy Column – By Delimiter.
Split at : Left – most delimiter.
2. Select [schema.2] – Transform – Pivot Column.
Values Column – [Flag]
Aggreate Value Function – Don’t Aggregate
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly