How to see all the values in a Matrix instead of just First one?

[kkaushi4]

Hi All,

I am working on a problem which have multiple values(string) for a particular Month  and I want to see all the values in the Matrix view instead of just First. How can I do that?

Current View:

Group	M1	M2	M3	M4
A	Cricket	Football		BasketBall
B	BasketBall		BasketBall
C	Football		Cricket

Expected View

Group	M1	M2	M3	M4
A	Cricket Football	Football		BasketBall Football
B	BasketBall		BasketBall
C	Football Cricket		Cricket BasketBall

I think CONCATENATEX () can be used but don't hav

Thanks

[lbendlin]

Yes, CONCATENATEX.  

Please explain how you got from your sample data to the expected view.  I don't understand the logic.