Replacing a blank row with another row data with an if statement
Hi, I have an original set of data (table1), and I am trying to script it to the result in table 2. If any number that is below 300, will print "type1" string into "result1" column. If any number is above 300, will print "type2" string into "result2" column. Numbertype1type2result1result2100a1a2 200b1b2 150c1c2 275d1d2 555e1e2 424f1f2 572g1g2 783h1h2 125i1i2 Table1: Original data N...