Forum Discussion
Solved
Unpivot columns
Hi, The solution is probably easy, but I can't get it to work as the outcome is not the same if I manually calculate. I have an excelsheet covering the following: Article nr Article g...
Hi lekkerbek ,
Please follow the below steps to acheive your request.
- First Unpivot the columns Fig 1.1
- Split the columns based on space delimiter to the Right-most delimiter Fig 1.2 and 1.3.
- Pivot the Number and Values to columns based on Value column Fig1.4.
Fig 1.1:Fig 1.2:
Fig 1.3:
Fig 1.4:
Best Regards,
Mail2inba4
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You want something like below screen shot? (I tried to replica your requirement at my side)
Please Give KUDOS to my post and accept this as a solution if it helps you!
