Need help to build in table format

[ashmitp869]

Hi All,

Please suggest.

I have a date like 

I need to build it one.

I interpreter it like this :

Is this correct.?

And also help , how to build in Data modelling to get the data .

[edwin]

your bets bet is to use a pivot table.  the column in your picture to the left are your measures and the columns at the top is a single field.  here is a sample:

here is the data i used :

this is my expression for diagnostics and intervention:
concat(distinct Intervention&', ' &Disgnostics,', ')

that should give you an idea one possible implementation.

however, you normally start with your data.