Forum Discussion
Helper IICombining rows based on unique id, and combining information
Sorry, forgot to mention that you need to turn the aggregation off: last step: Advanced Opions: Don't aggregate bofore hitting the last OK.
Hi Imke,
I tried your solution for one of my data which i need in same format.
1) Check column ID -> Mouse rightclick -> Unpivot Other Columns: This will delete the nulls
2) Check column Attribute -> Transform -> Any Column -> Pivot Column: Choose "Value" in Values Column
But its giving error "There were too many elements in the enumeration to complete the operation.". Can you please help?
Regards,
Shruti
I had the same problem but i solved it by adding this after step 1:
1) Check column ID -> Mouse rightclick -> Unpivot Other Columns: This will delete the nulls
1.1) Select Column ID and Attribute together -> mouse right click -> remove duplicates
2) Check column Attribute -> Transform -> Any Column -> Pivot Column: Choose "Value" in Values Column (Advanced Options: Don't aggregate bofore hitting the last OK.)