splitting range of rows in separate column

3 visualizaciones (últimos 30 días)
NAVEED ULLAH
NAVEED ULLAH el 8 de Oct. de 2022
Comentada: Chris el 8 de Oct. de 2022
i have a large excel data. it has two column. i want to splitt every 17 rows in separate column in the same sheet
how can i do it in matlab?

Respuesta aceptada

Chris
Chris el 8 de Oct. de 2022
Editada: Chris el 8 de Oct. de 2022
A = readmatrix('filename.xlsx');
len = size(A,1);
% Make sure array length is divisible by 17.
B = padarray(A,[17-mod(len,17), 0],NaN,'post');
% Reshape each column
wid = size(B,1)/17;
C(:,1:3:3*wid) = reshape(B(:,1),17,wid);
C(:,2:3:3*wid+1) = reshape(B(:,2),17,wid);
% Clear out the zeros in between columns
C(:,3:3:end) = nan;
% Write to file
writematrix(C,'newfile.xlsx')
Is this what you mean?
  4 comentarios
NAVEED ULLAH
NAVEED ULLAH el 8 de Oct. de 2022
Thank you so much.
Chris
Chris el 8 de Oct. de 2022
No problem.

Iniciar sesión para comentar.

Más respuestas (0)

Community Treasure Hunt

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

Start Hunting!

Translated by