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

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.

 採用された回答

KSSV
KSSV 2022 年 1 月 2 日

0 投票

T = readtable('data.xlsx') ;
T = table2array(T) ;
T = T' ;
T = T(:) ;
plot(T)

その他の回答 (1 件)

Matt J
Matt J 2022 年 1 月 2 日

0 投票

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 件のコメント

Changhyun Kim
Changhyun Kim 2022 年 1 月 2 日
NOPE...Since it is a ground acceleration value, it must be arranged in order.

サインインしてコメントする。

質問済み:

2022 年 1 月 2 日

回答済み:

2022 年 1 月 2 日

Community Treasure Hunt

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

Start Hunting!

Translated by