How to interleave data from 2 doubles of differing length?
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Cyrus Yousefian
il 28 Set 2022
Commentato: Cyrus Yousefian
il 28 Set 2022
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 Commenti
Risposta accettata
Jan
il 28 Set 2022
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?
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Numeric Types in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!