Transform data to delete duplicate Rows Table.TransformColumns

[DavidEg]

Hello, I have a query similar to as below screenshot shown

I would like to transform it so that it does not have duplicate rows of the student column and group the class fields as follows:

I'm using these M queries, but I can't get the expected result.

I have tried the following queries:

Table.SplitColum Table.TransformColumns

Has anyone transformed the data in a similar way and can help me?

Thank you so much for everything.

[DavidEg]

Thank you very much, I've got it.

I googled and found nothing.

I've done as the consultation says.

I grouped the column and then combined the rows as text.

= Table.Group(Origen, {"student"}, {{"Recuento", each Text.Combine([classes.1], "; "), type text}})

Thank you so much for everything!!

[amitchandak · Accepted solution]

@DavidEg , refer to the form of energy consultation

https://www.excel-university.com/combine-rows-into-a-delimited-list/

https://exceloffthegrid.com/power-query-combine-rows-into-a-single-cell/

in dax use this measure with Student in a visual table/matrix

concatenatex(Table, table[class], ",")