Pivot Column String Display Unique Rows

https://snippet.webix.com/qnnw11et

How can I change my data to show a unique item for each row instead of being comma separated?

For example, in the link above when you remove year from the Columns, it shows Argentina, Oil as 1.545, 1.732, 2.845, 4.333, 2.626, 4.474, 9.414, 10.496, 10.85.

I want it to show each of those as it’s own row.
Argentina 1.545
Argentina 1.732
Argentina 2.845
.
.
.

Hello @annie123 ,

How can I change my data to show a unique item for each row instead of being comma separated?

Unfortunately, it’s impossible. Please note that Pivot Table is a showcase for the result of data aggregation.
As alternative solution, you can separately access the original data and parse to datatable, for example:
https://snippet.webix.com/6fdxhshw