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

3 views (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
  1 Comment
Changhyun Kim
Changhyun Kim on 2 Jan 2022
NOPE...Since it is a ground acceleration value, it must be arranged in order.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!