SQL & PL/SQL :: Pivoting Data (rows To Columns)

I have a table like below-

create table test (cust_id number(3), m_no number(1), other_date varchar2(20));

Where there is a "cust_id" that can have maximum 3 "m_no" (Don't bother for that condition, we have it in actual table).

In this table records are as follows.

insert into test values (1,1,'ABC');
insert into test values (1,2,'DEF');
insert into test values (2,1,'DEG');
insert into test values (3,2,'DEG');

[Code]..

My objective is to get date like below--

cust_idf_m_nof_oth_datas_m_nos_oth_datat_m_not_oth_data

1 1 ABC 2 DEF
2 1 DEG
3 2 DEG 1 BCD 3 MNO
4 9 KLM
5 2 XYZ 5 XAZ

I want to say, that cust_id's that doesn't have second and third m_no should not have any data in those columns.

Can this be performed through single query, or I need to make temporary tables or functions for this.