how to skip and split specific range of rows in to multiple columns ?

2 views (last 30 days)
I have long data like thais in one colmun
0.00248
0.00310
0.00377
0.00459
0.00558
120
0
0
NaN
0.002480
0.003100
0.003770
0.004590
0.005580
I want to read first 5 rows in first colmun and skip the next 4 rows and read next five rows as second colmun.
like that I want to do for entire my long colmun data.
How can I do that ?

Accepted Answer

Walter Roberson
Walter Roberson on 17 May 2020
D = load('YourFile.txt');
N = length(D);
R = mod(N,9);
if R ~= 0
D(end+1:end+9-R) = nan;
end
Dcols = reshape(D, 9, []);
Dcols(6:end,:) = [];

More Answers (0)

Categories

Find more on Tables 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!