Unable to change data from row to column by using transpose

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

Answer 1

[Wayne King]

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.

[Gil Cheah]

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

[Wayne King]

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.

[Gil Cheah]

Thanks, now i can extract those information with that!