Excel : Transpose group of data use formular

[i3erriiz]

I want to make this 

R.M. 1	6683-19-8
R.M. 2	512-56-1
R.M. 3	51541-08-3
R.M. 4	25750-84-9
R.M. 5	471-34-1
R.M. 6	9002-84-0	25852-37-3
R.M. 7	110-30-5
R.M. 8	65997-17-3
R.M. 9	1309-64-4
R.M. 10	71342-77-3
R.M. 11	26062-94-2	68308-22-5	1333-86-4	73138-44-0
R.M. 12	26062-94-2

Into this so later i use for calculation what formular to use?

R.M. 1	6683-19-8
R.M. 2	512-56-1
R.M. 3	51541-08-3
R.M. 4	25750-84-9
R.M. 5	471-34-1
R.M. 6	9002-84-0
R.M. 6	25852-37-3
R.M. 7	110-30-5
R.M. 8	65997-17-3
R.M. 9	1309-64-4
R.M. 10	71342-77-3
R.M. 11	26062-94-2
R.M. 11	68308-22-5
R.M. 11	1333-86-4
R.M. 11	73138-44-0
R.M. 12	26062-94-2

[#2]

@i3erriiz 

For such model

formula could be

=LET(
     cols, COLUMNS(Table1),
     rws,  ROWS(Table1),
     k,    SEQUENCE((cols-1)*rws),
     row,  INT((k-1)/(cols-1))+1,
     col,  MOD(k-1,cols-1)+2,
     data, INDEX(Table1,row,col),
     name, INDEX(Table1,row,1),
     IF({1,0},
        FILTER(name,data<>0),
        FILTER(data,data<>0)
     )
)