How to interleave data from 2 doubles of differing length?
1 回表示 (過去 30 日間)
古いコメントを表示
I want to interleave 2 doubles of differing length so that I end up with 2 doubles of the same length with empty cells so when it is output to excel it shows blanks.
Say I have these two doubles.
(in my actual code A is 57x1 and B is 446x1, not sure if that helps?)
A=[1;2;11;20];
B=[3;4;5;6;7;8;9;10;12;13;14;15;16;17;18;19];
I want to end up with
(not sure what an empty cell is for doubles, NaN maybe?)
A=[1;2;blank;blank;blank;blank;blank;blank;blank;blank;11;blank;blank;blank;blank;blank;blank;blank;blank;20];
B=[blank;blank;3;4;5;6;7;8;9;10;blank;12;13;14;15;16;17;18;19];
I do not care if the result is a double or a cell matrix.
0 件のコメント
採用された回答
Jan
2022 年 9 月 28 日
A=[1420;2956;4492;6028];
B=[2960;3152;3344;3536;3728;3920;4112;4304;4496;4688;4880;5072;5264;5456;5648;5840];
[C, idx] = sort([A; B]);
idxa = (idx <= numel(A));
AB = NaN(numel(C), 2);
AB(idxa, 1) = A;
AB(~idxa, 2) = B;
AB
Now the array is created, but this might be an open problem: "when it is output to excel it shows blanks". How do you export this to Excel?
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Numeric Types についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!