merging cells in table

[Anshenterprices]

Source data

CollegeName	Class	noofstudents
ABC	FY	60
ABC	SY	80
ABC	TY	50
XYZ	st	40
XYZ	nd	70
XYZ	rd	30

i want below output but i dont want matrix table

CollegeName

Class

noofstudents

                                     FY          60
  Abc                             SY          80

                                     TY           50
                                    ST            40
XYZ                               nd            70
                                    rd               30
   

[amitchandak · Accepted solution]

@Anshenterprices , This best possible in matrix

or try

concatenated(Table, Table[Class] & " " & Table[noofstudents],unichar(10))

or

concatenated(Table, Table[Class] & " " & Table[noofstudents] & unichar(10))

[Anshenterprices]

@amitchandak  I have used the matrix then turned off the row_header stepped layout from the property of matrix and after that i opened all the + icons and then turn off the  +/- Icon from the property of matrix. its sorted finally its looks like simple table now

[v-henryk-mstf]

Hi @Anshenterprices ，

As mentioned above, the best way to show the results is to create a matrix visual. If your question has been solved, you can mark the correct response as a standard answer to help the other members find it more quickly.

If the problem is still not resolved, please provide detailed error information. Looking forward to your reply.🙂

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.