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.
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.
