Group rows in one column by another column.

Hi

I want to convert this to two rows: 

So that it looks like this:

I've tried the usual 'group by' and pivoting, but I've got stuck!

I've also been experimenting with converting tables to lists and records..

Many thanks for looking.