How to condition on one column with different values and print-out paired values in next column in multiple columns?
Here you go...

Data &amp; structure:

create table mytable
(
ids number,
vals varchar(5)
);

insert into mytable values(0, 'A+');
insert into mytable values(1, 'A');
insert into mytable values(1, 'D');
insert into mytable values(2, NULL);
insert into mytable values(0, 'A');
insert into mytable values(2, 'C');
insert into mytable values(1, NULL );
insert into mytable values(3, 'C');


Test:

SQL&gt; select NVL(case when ids=0 then vals else '-' end,'*') as x0IDs,
  2         NVL(case when ids=1 then vals else '-' end,'*') as x1IDs,
  3         NVL(case when ids=2 then vals else '-' end,'*') as x2IDs,
  4         NVL(case when ids=3 then vals else '-' end,'*') as x3IDs
  5  from mytable;

X0IDS X1IDS X2IDS X3IDS
----- ----- ----- -----
A+    -     -     -
-     A     -     -
-     D     -     -
-     -     *     -
A     -     -     -
-     -     C     -
-     *     -     -
-     -     -     C

8 rows selected.

SQL&gt;