Looking for moving single column into multiple columns base on 1st character

My PL SQL skills are terrible. I'm sure for someone who uses PL SQL this is a simple task, but I've only had to us PL SQL about 10+ years ago. PL SQL is not needed often in my work.

Looking to move data from a single column table into a 4 column table based on first char of the data.

current table created from using sqlldr, parsing a stream of data into rows.

live> desc cyc_data

 Name                   Null?  Type

 ----------------------------------------- -------- ----------------------------

 DATA1                       VARCHAR2(21)

 

 1* select * from cyc_data order by rowid

live> /

 

DATA1

---------------------

CWR

R0000806

S116153323

Q00009

S160166044

Q00008