Is it possible to condense duplicate cells/rows in matrix visuals, effectively removing them?

[Anonymous]

Hello all, I'm facing an issue with a particular visual. I'd need to remove duplicate entries from a matrix, whose starting raw data is as follows:

I've split both names columns by the comma, per rows, getting the intended result:

Which is exactly why I need for the rest of the report. However, when trying to create a simple display in the form of a matrix, I get the following (which I know to be working as intended, given the repetition in the source data):

However, for end-users, this simply wouldn't work. What I would need is a clean matrix/table with the unique names listed in the same manner, but no repetitions on any of the columns. For example:

15691	Petter	Joseph
	Anna	Rogers
		Michael

Thus, clicking on 15691would highlight solely the names belonging to that ID, greying out the remaining. Obviously this matrix works for rows which only have a single name in both Original and Final, but only for those specific rows.

Is what I'm trying to achieve something that's even possible, either in a matrix or using another visual? Very much appreciate any help on this!

Thank you

[Greg_Deckler]

@Anonymous I feel like perhaps you would have to change your Source Original to be a measure perhaps and you might have to use a table visual to boot. Basically, you would need something like this:

Source Original 2 = CONCATENATEX( 'Table', [Column], UNICODE(10) && UNICODE(13) )