There was an example of formula that returns only positive values from a range in John Walkenbach old book Microsoft Bible 2003.
(Chapter 15, Working with Multicell Array Formulas). In case all data are stored in column range Data the formula takes the following view:
=IF(ISERR(SMALL(IF(Data>0;ROW(INDIRECT("1:"&ROWS(Data))));ROW(INDIRECT("1:"&ROWS(Data)))));"";INDEX(Data;SMALL(IF(Data>0;ROW(INDIRECT("1:"&ROWS(Data))));ROW(INDIRECT("1:"&ROWS(Data))))))

My question is what I need to change in the above formula if Data is not a column range, but a row range?

I tried to change all ROW to COLUMN and all ROWS to COLUMNS, but that only caused N/A to show up in all cells..