Path: news.mathworks.com!not-for-mail
From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: rearranging a matrix
Date: Sat, 18 Feb 2012 14:52:11 +0000 (UTC)
Organization: The MathWorks, Inc.
Lines: 24
Message-ID: <jhodur$ega$1@newscl01ah.mathworks.com>
Reply-To: <HIDDEN>
NNTP-Posting-Host: www-02-blr.mathworks.com
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: newscl01ah.mathworks.com 1329576731 14858 172.30.248.47 (18 Feb 2012 14:52:11 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Sat, 18 Feb 2012 14:52:11 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 58650
Xref: news.mathworks.com comp.soft-sys.matlab:758113

Hi all,

I loaded data from excel into matlab and it is now in the following format:

NaN NaN NaN
NaN NaN NaN
1 2 3
4 5 6
NaN NaN NaN
NaN NaN NaN
7 8 9
10 11 12
NaN NaN NaN
NaN NaN NaN
13 14 15
16 17 18

How can I arrange these data into the following format?

1 2 3 4 5 6
7 8 9 10 11 12
13 14 15 16 17 18

Best regards!