Transposing row-like data in DB table

SELECT 
    dataset_uuid,
    step,
    MAX(CASE WHEN parameter_name = 'NAME1' THEN value END) AS NAME1,
    MAX(CASE WHEN parameter_name = 'NAME2' THEN value END) AS NAME2,
    MAX(CASE WHEN parameter_name = 'NAME3' THEN value END) AS NAME3,
    MAX(CASE WHEN parameter_name = 'NAME4' THEN value END) AS NAME4,
    MAX(CASE WHEN parameter_name = 'NAME5' THEN value END) AS NAME5,
    MAX(CASE WHEN parameter_name = 'NAME6' THEN value END) AS NAME6,
    MAX(CASE WHEN parameter_name = 'NAME7' THEN value END) AS NAME7,
    MAX(timestamp) AS timestamp
FROM table1
GROUP BY dataset_uuid, step
ORDER BY dataset_uuid, step;

https://dbfiddle.uk/W0qHVgFZ

See example with CROSSTAB for PostgreSql.

crosstab(source_sql, category_sql)

CROSSTAB source query will return rows with 3 column
row_name - row idetifier ,category - column name for transposed table, value - value in result table.

Create identifier rn for tuple(dataset_uuid,step,timestamp) as rank()over(dataset_uuid,step). Timestamp ignored:)
We use this identifier in CROSSTAB instead tuple.

with testN as(
  select *,rank()over(order by dataset_uuid,step) rn
  from test
)
select rn,parameter_name,value
from testN

Main query with crosstab.
category_sql as list of values
$$values('NAME1'),('NAME2'),('NAME3'),('NAME4'),('NAME5'),('NAME6'),('NAME7'),('NAME8')$$

SELECT a.dataset_uuid,a.step,a.timestamp,ct.* FROM 
crosstab(
$$with testN as(
  select *,rank()over(order by dataset_uuid,step) rn
  from test
)
select rn,parameter_name,value
from testN
  $$
,$$values('NAME1'),('NAME2'),('NAME3'),('NAME4')
         ,('NAME5'),('NAME6'),('NAME7'),('NAME8')$$
) AS ct(rn bigint, "NAME1" float, "NAME2" float, "NAME3" float, "NAME4" float
          , "NAME5" float, "NAME6" float, "NAME7" float
       , "NAME8" float)
left join (
  select distinct dataset_uuid,step,timestamp,rank()over(order by dataset_uuid,step) rn
  from test
)a on ct.rn=a.rn
ORDER BY rn;

Test data

with testN as(
  select *,rank()over(order by dataset_uuid,step) rn
  from test
)
select dataset_uuid,step,rn,parameter_name,value
from testN

If necessary, add extension tablefunc

CREATE EXTENSION IF NOT EXISTS tablefunc;

fiddle