MATLAB Answers


Unable to change data from row to column by using transpose

Asked by Gil Cheah on 20 Jun 2017
Latest activity Commented on by Gil Cheah on 21 Jun 2017
I imported the data from excel file, and the data is needed to run with wavelet 1-D analysis. After entering the wavemenu, it said that my data is not in 1-D dimension, so i guess that my data have to listed as column instead of row. However, I have unable to transpose the data by using A.' or A'
This is the showed on my command window "Error using ' (line 148) Undefined function 'ctranspose' for input arguments of type 'table'."
Anyone can tell me why? Thanks in advance


Sign in to comment.

1 Answer

Answer by Wayne King
on 20 Jun 2017
 Accepted Answer

Is the data in your workspace in the form of a MATLAB table?
What does the >>whos
command print out in your workspace? or better yet, let's say the data is stored in your MATLAB workspace as X, what does >>class(X)
print out.


yes, it is a table. I just realised that this only happens when I import data directly via 'Import Data' on the 'Home' tab. And if I typed xlsread(x), it became 'double' class which I can transpose.
But it is not convenient because through xlsread(x), some 'date' data is missing
I glad you helped
You can also extract a numeric vector from a a table() with table2array()
load patients
patients = table(LastName,Gender,Age,Height,Weight,Smoker,Systolic,Diastolic);
weight = table2array(patients(:,4)); % extract weight variable as vector
The Wavelet 1-D tool will not care if your signal is a row or column vector.
Thanks, now i can extract those information with that!

Sign in to comment.