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.
The error occurs because the titles "Estilo Personal" and "Áreas de Mejora" appears several times. I show you the difference between the error and the rows OK:
Before pivot:
Error example: 503
Example OK: 450
As you can see the difference are the duplicates of the titles. But as i said if i eliminate them it will eliminate all the info of the column "Value"
Thanks
If you add
each Text.Combine(_, "#(lf)")
as the 5th parameter to your Table.Pivot function, you'll get all the different rows combined with a line break in your pivot table.