Arrange data of an array in certain order.
1 view (last 30 days)
Show older comments
Hi, currently I have a datasheet in alphabetic order (3 column X, Y and Z for each variable). how I want to rearrange the datasheet in certain specific order.?
Attached herewith the txt.file and xlsx.file.
The order in the datasheet is
C1, C2....FAM, FCC,...
However, i need to arrange it
FM2,FCC,..C1,...
Thank you in advance!
0 Comments
Answers (1)
Piyush Lakhani
on 12 Mar 2020
Hi,
First read the text file and X,Y,Z data for indiviual variables.
D=xlsread('DynamicDW.xlsx')
C1=D(:,[1:3]);
C2=D(:,[4:6]);
%Like wise all the variables
FAM=D(:,[start:end])
% Then
Rearrage=[FM2 FCC C1 C2 ] %Write all variables
0 Comments
See Also
Categories
Find more on Electrical Block Libraries in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!