[SQL] Oracle Table transpose

Below is my table

CREATE TABLE "TABLE1"
( "REG" VARCHAR2(20 BYTE),
"SB" VARCHAR2(20 BYTE),
"VKYC" VARCHAR2(20 BYTE)
) ;

Insert into TABLE1 (REG,SB,VKYC) values ('1','2','3');
Insert into TABLE1 (REG,SB,VKYC) values ('1A','3','6');
Insert into TABLE1 (REG,SB,VKYC) values ('2','4','7');
Insert into TABLE1 (REG,SB,VKYC) values ('3','5','8');
Insert into TABLE1 (REG,SB,VKYC) values ('4','6','9');
Insert into TABLE1 (REG,SB,VKYC) values ('5','7','0');


I want result like transpose:

Reg​

1​

1A​

2​

3​

4​

5
Sb​

2​

3​

4​

5​

6​

7
Vkyc​

3​

6​

7​

8​

9​

0​

Continue reading...