Extracting a continuous list based on criteria

Dear Forum,

Is there a way I can get a continuous list, ie no missing rows, from a much larger list. (New list in separate columns to the R of the list.)

I want to extract data from column A, only if the data in col C matches my specified criteria - I want this info to appear as a list with no gaps, ie I can do this easily using "If" but there will be lots of blank rows doing it this way.

Furthermore, as I need two different lists from the same data block, I need to specify whether number (extract these to col N) or text (extract to col O).

Have explained fully (I think) in attached - will be grateful for any help

Bungaree