How to convert 183*5 matrix data into column vector data

1 view (last 30 days)
I am wondering how to convert excel data in 183*5 matrix into column vector data.
I hope to get the general code that converts excel data in m*5 matrix as well as 183*5 into column vector data.
plz, help me and refer to the attached excel file.
Also, Since it is a ground acceleration value, it must be arranged in order.

Accepted Answer

KSSV
KSSV on 2 Jan 2022
T = readtable('data.xlsx') ;
T = table2array(T) ;
T = T' ;
T = T(:) ;
plot(T)

More Answers (1)

Matt J
Matt J on 2 Jan 2022
You mean like this?
x=rand(183,5);
y=x(:);
whos x y
Name Size Bytes Class Attributes x 183x5 7320 double y 915x1 7320 double

Community Treasure Hunt

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

Start Hunting!