Forum Discussion
Solved
Combining rows based on unique id, and combining information
Hi, This is my first post on this forum, but I've been 'lurking' around for a while, learning as I go. Hopefully one of you BI-wizards can help me out with my particular case for which I couldn't...
Sorry, forgot to mention that you need to turn the aggregation off: last step: Advanced Opions: Don't aggregate bofore hitting the last OK.
This is one of my favourites :-)
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