how to concatenate the two variables.?

6 views (last 30 days)
how to concatenate the two variables a(1*5) cell and b(3*5) double
ex:
a= ch1_01 ch1_02 ch2_01 ch2_02 ch3_01
b=
12.2172 83.1253 32.3429 73.2126 43.3222
32.2179 13.1213 42.3388 53.5127 52.1229
82.2571 43.1231 52.1400 33.4129 44.3326
output: in one variable as
ch1_01 ch1_02 ch2_01 ch2_02 ch3_01
12.2172 83.1253 32.3429 73.2126 43.3222
32.2179 13.1213 42.3388 53.5127 52.1229
82.2571 43.1231 52.1400 33.4129 44.3326

Accepted Answer

Mischa Kim
Mischa Kim on 13 Mar 2014
Edited: Mischa Kim on 13 Mar 2014
Sandy, you could do:
a = {'ch1_01' 'ch1_02' 'ch2_01' 'ch2_02' 'ch3_01'};
b = [12.2172 83.1253 32.3429 73.2126 43.3222;...
32.2179 13.1213 42.3388 53.5127 52.1229;...
82.2571 43.1231 52.1400 33.4129 44.3326];
c.col = a;
c.val = b;
To access the different components use, e.g.,
c.col(2)
c.val(1:2,2:3)
  2 Comments
sandy
sandy on 13 Mar 2014
thanks..how to save this structure variable as an excel file??
Mischa Kim
Mischa Kim on 13 Mar 2014
This should do:
filename = 'testdata.xlsx';
sheet = 1;
xlswrite(filename,c.col,sheet,'A1')
xlswrite(filename,c.val,sheet,'A2')

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!