Multiple ID Rows into Columns

[Syndicate_Admin]

Tried searching but couldnt find exactly what i needed.

I have a database with data over multiple columns and same ID, like this:

but i need it in a format like

data_id	Team	Location	comments
9	erron	Honour

[Syndicate_Admin]

Worked perfectly, thank you!!

[wdx223_Daniel · Accepted solution]

NewStep=Table.FromRecords(Table.Group(PreviousStepName,"data_id",{"n",each _{0}[[data_id]]&Record.FromList([value],[name])})[n])