Many to One String Values in Pivot

[#1]

Hi - we are trying to represent a cross-table type view three dimensions. "Apps" are 1:1 to "Countries" but "Functional Services" (FS) can have many Apps.

e.g, each app belongs to 1 country but to many functional services, and FS's have many apps. You can use "concat" but the multiple values are all on one line - is there a way to break these out like in an embedded list/group or in separate rows?

Currently use:

This is the result of a standard pivot but multiple values are concatenated in one cell (e.g. ENG:FS1). Can they be listed (like a nested list?

Source data:

Thanks for any ideas!

[tresesco]

Your source data is already row-wise. Did not really get your requirement point.

[#3]

Hi - thanks - it's more about presentation - it needs to look like a heat-map (there will be colour formatting applied) with a horizontal dimension and vertical dimension and the results listed as cells rather than concatenated in one cell.

[sujeetsingh]

Drag the dimension to Horizontal view

[#5]

thanks - the horizontal dimension is OK, just there are many string results per cell - they need to be concatenated as per top pic and we'd like separate cells, or an embedded list-  I don;t think this is possible.