Borrar filtros
Borrar filtros

merge two cell in one single cell

1 visualización (últimos 30 días)
Ahmed
Ahmed el 24 de En. de 2016
Comentada: Ahmed el 25 de En. de 2016
I have two cells. one of them is
Cell 1=
'1007_s_at' 780 'DDR1'
'1053_at' 5982 'RFC2'
'117_at' 3310 'HSPA6'
'121_at' 7849 'PAX8'
'1255_g_at' 2978 'GUCA1A'
'1294_at' 7318 'UBA7'
'1316_at' 7067 'THRA'
'1320_at' 11099 'PTPN21'
'1405_i_at' 6352 'CCL5'
'1431_at' 1571 'CYP2E1'
'1438_at' 2049 'EPHB3'
'1487_at' 2101 'ESRRA'
'1494_f_at' 1548 'CYP2A6'
'1598_g_at' 2621 'GAS6'
and
cell 2=
2x1 cell 2x1 cell 2x1 cell
2x1 cell 2x1 cell 2x1 cell
2x1 cell 2x1 cell 2x1 cell
2x1 cell 2x1 cell 2x1 cell
2x1 cell 2x1 cell 2x1 cell
3x1 cell 3x1 cell 3x1 cell
3x1 cell 3x1 cell 3x1 cell
4x1 cell 4x1 cell 4x1 cell
3x1 cell 3x1 cell 3x1 cell
7x1 cell 7x1 cell 7x1 cell
I used cat to merge that but I did not get the result that I want:
'1007_s_at' 780 'DDR1'
'1053_at' 5982 'RFC2'
'117_at' 3310 'HSPA6'
'121_at' 7849 'PAX8'
'1255_g_at' 2978 'GUCA1A'
2x1 cell 2x1 cell 2x1 cell
2x1 cell 2x1 cell 2x1 cell
2x1 cell 2x1 cell 2x1 cell
I want the result like cell 1 .
Any help will be highly appreciated

Respuestas (1)

Walter Roberson
Walter Roberson el 24 de En. de 2016
[cell1; [vertcat(cell2{:,1}), vertcat(cell2{:,2}),vertcat(cell2{:,3})]]
  4 comentarios
Walter Roberson
Walter Roberson el 25 de En. de 2016
Could you post a small amount of the data for cell2 ? I tested before posting with data that looked to be like what you described.
Ahmed
Ahmed el 25 de En. de 2016
Sure
2x1 cell 2x1 cell 2x1 cell
2x1 cell 2x1 cell 2x1 cell
inside each cell for example first row these data:
'200080_s_at' '3020' 'H3F3A '
'200080_s_at' '440926' ' LOC440926'

Iniciar sesión para comentar.

Etiquetas

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by