Forum Discussion
Solved
How Convert an excel data in transpose
Hi Experts, I have a issue with a excel file with the following format: You can see that there are a column by quarter/Product code Code Description Mar-23 Jun-23 Sep-23 Dec-23 Mar-...
Hello gomezc73
You can use unpivot in power query to achieve this. Select all the columns expect code, description and do unpivot selected columns as below.Let me know if this helps!
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Hello gomezc73
You can use unpivot in power query to achieve this. Select all the columns expect code, description and do unpivot selected columns as below.
Let me know if this helps!
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Worked perfect. Thank you!!!