Merge or group rows by ID

[JohnD78]

Appologies, I know what I want but don't know how to search for the solution as I don't know what terminology to use.

I would like to merge the contents of six rows into one.  A sample of the data is below to help you visualise.  Each Business has a "score" for each "condition".

I used power Bi to create a conditional column for each "Condition" and put the corresponding score in for each.  See image below.  The plan was to then merge rows by Assessment ID and fill in the blanks but I don't know what terminology to use, group by was greyed out as you cant use that for data.

Now I would like to try and merge the rows with the same "Assessment ID" into a single row, something like the image below, although in all honesty the Condition column isn't needed like it is on the image below.

Is what I'm looking to do possible in power Bi?, or excel?

Thanks in advance.

[JohnD78]

Thanks @Ibendlin that worked a treat, after a bit of work wrking out that it should be values instead of columns

[lbendlin · Accepted solution]

Load your data as is into Power BI. Let the Matrix visual do the pivoting.