Clear Filters
Clear Filters

merge two cell in one single cell

2 views (last 30 days)
Ahmed
Ahmed on 24 Jan 2016
Commented: Ahmed on 25 Jan 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

Answers (1)

Walter Roberson
Walter Roberson on 24 Jan 2016
[cell1; [vertcat(cell2{:,1}), vertcat(cell2{:,2}),vertcat(cell2{:,3})]]
  4 Comments
Walter Roberson
Walter Roberson on 25 Jan 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 on 25 Jan 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'

Sign in to comment.

Tags

Community Treasure Hunt

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

Start Hunting!