You're correct on both fronts - posting DDL and not using Pivot. I'm working on getting the DDL together. Below is another query I wrote only works for one parameter at a time and null is placed for every subsequent 100 rows.

SELECT a.serialno, e.name,
case when rownum between 1 and 101  then column end as "PT",
case when rownum between 102 and 203 then column end as "PP",
case when rownum between  204 and 305 then column end as "PS",
case when rownum between  306 and 407 then column end as "PF,
case when rownum between  408 and 509 then column end as "FT",
case when rownum between  510 and 611 then  column end as "FP",
case when rownum between  612 and 713 then column end as "FS",
case when rownum between  714 and 815 then column end as "FF",
b.cycletime
from unit a
join data b on a.tid = b.tid
join config e on a.id = e.id
join header c on b.testid = c.testid
join points d on c.headerid = d.headerid
where a.serialno in ('1112222333');