How to duplicate rows while skipping/excluding specific rows?

What I have:

I have a cell array:

That second column is the data that is nested into the first column.

What I need:

I need each number (that is not 1000) duplicated. These numbers correspond to data in another matrix, so the Indicies MUST match. I'm at a loss.

My current attempt:

The final matrix PRN should be the same size as A (so the indexes match). It is missing 1173 rows of data. My current theory is that there are other blank lines in the data that (for god knows what reason) don't need to be deleted.

This is a piece of a function that is trying to parse data from many many files. So I hope I gave you enough information to work off of.

Thanks for any help, ideas or refrence materials that you might send my way.

Answer 1

[Jan]

C   = str2double(A(~cellfun('isempty', A)));
idx = repmat(1:numel(A), 2, 1);
idx(2, C == 1000) = 0;
PRN = C(idx(idx ~= 0));

[Jayne]

Thank you for your answer. That does double it and is very efficient. I still have rows missing, but I think the problem is in my data/assumptions, not your code.