old record example
Sample# 1234567
test1result 2.45
test2result
test3result 1.12
..test55result 4.24

I only want to copy where there is a value, either zero or a number.
I can't find a way to exclude test2 since it is blank. (There 55 result fields but usually only 5 - 10 have a value).
new record layout
Sample# Test# Result

Something like
Select 1
IF !(ALLTRIM(STR(test1result)) = " ") then
value = test1result
select 2
append blank
replace sample# with samplevaraible
replace test# with 5
replace result with value
ENDIF

Thanks for any help.