How to change single column to multiple columns with values in power query editor?
Below is the input table in power query editor:
enter image description here
Expected output:
enter image description here
Tried using Pivot Columns and Transpose but error appearing and output not coming as expected.
Will be helpful if someone guide.
Thanks!
Below is the input table in power query editor:
enter image description here
Expected output:
enter image description here
Tried using Pivot Columns and Transpose but error appearing and output not coming as expected.
Will be helpful if someone guide.
Thanks!
Amit Chavan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.