how to concatenate the two variables.?

9 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)

Categories

Find more on Matrices and Arrays in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!