Forum Discussion
Combining 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.
Sorry, but I cannot find any clarification in you latest post.
Please keep your samples to the first 3 "Legajo"s: 154, 219 and 305:
- What do they contain? (You can use the formula I've suggested, but don't have to. Otherwise just paste the raw data)
- How do you want to visualize them?
The source of your data is irrelevant at this stage.
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.