!!!Very challenge - copy one row to following two row

I have a excel file, in row 11, I have some headers. A11 is Date, B11 is Time, C11-G11 is P1 to P5. Starts row 12, there are data.

I want to copy one row data to following two row, like copy Time 0:00:00 copy to 0:05:00, 0:10:00. copy time 0:15:00 to 0:20:00, 0:25:00.

I have example as following.

          A            B       C     D     E     F    G
   11   Date        Time       P1    P2    P3   P4    P5
   12  1/12/2016    0:00:00    1     1     No    No   No
   13  1/12/2016    0:15:00    2     2     Yes   Yes  Yes
   14  1/12/2016    0:30:00    3     3     No    No   No
    .  1/12/2016    0:45:00    ..........................
    .  1/12/2016    1:00:00    ..........................
    .  1/12/2016    1:15:00    ..........................
    .....................................................
    .....................................................
  107  1/12/2016    23:45:00   .........................

         A            B       C     D     E     F    G
  11    Date        Time      P1    P2    P3    P4   P5
  12  1/12/2016    0:00:00    1     1     No    No   No
  13  1/12/2016    0:05:00    1     1     No    No   No
  14  1/12/2016    0:10:00    1     1     No    No   No
  15  1/12/2016    0:15:00    2     2     Yes   Yes  Yes
  16  1/12/2016    0:20:00    2     2     Yes   Yes  Yes
  17  1/12/2016    0:25:00    2     2     Yes   Yes  Yes
  .....................................................
  .....................................................

Answer 1

[Ced]

Well, once you have the data in matlab ( use xlsread ), let's say in matrix A, you could do:

[N_rows, N_cols] = size(A);
A = reshape(repmat(A,1,3)',N_cols,[])';

After that, all you need to do is replace the time, e.g.

A(:,2) = (0:5:(N_rows-1)*5)';

If you import the data in minutes.

The first operation is a bit hard to explain in words, but I'll try:

1. Copy the data, twice. (repmat)

2. But I want the data below, not on the side! So I transpose, tell matlab to cut to a new column after N_cols steps. (reshape)

3. Now the data is ordered correctly, but still transposed, so transpose back. ()'

Done!

*EDIT* : Adjusted typo in repmat as pointed out below.

[Jason]

1: I think this line should be

A = reshape(repmat(A,1,3)',N_cols,[])';

Since I want to get three same line after I copy from original one?

------------------------------------------------------------------------------

2: When I run the following, I got the error. Any solution?

>> A(:,2) = (0:5:(N_rows-1)*5)';

Subscripted assignment dimension mismatch.

[Ced]

Yes, of course, thanks! Edited it.

The error usually means that you try to access an index which does not exist, or try to assign it some object which has the wrong shape. Make sure that A(:,2) and (0:5:(N_rows-1)*5)' have the same dimensions. You may have accidentally changed the size of A in one of your operations.

[Jason]

Hi, I just follow your code, but still get the same error, I did not change the size of A.

2: When I run the following, I got the error. Any solution?

>> A(:,2) = (0:5:(N_rows-1)*5)';

Subscripted assignment dimension mismatch.

[Ced]

just before the assignment, can you try this and tell me what the output is?

disp('size A')
size(A(:,2))
disp('size t')
size((0:5:(N_rows-1)*5)')

[Jason]

Sorry for the late reply. I just saw your reply. I did not get notified when you replied.

disp('size A')
size(A(:,2))
disp('size t')
size((0:5:(N_rows-1)*5)')
size A

ans =

       9     1

size t

ans =

       3     1