Fiddle percentages into real numbers
Get rid of the '%' symbols and shift the decimal place. This is the easier version - all the columns line up.
Start file
1,25.1%,good 2,19.8%,bad 3,30.5%,bad 4,71.4%,good 5,16.8%,bad 6,93.9%,good 8,37.1%,bad 9,35.3%,bad
End file
1,.251,good 2,.198,bad 3,.305,bad 4,.714,good 5,.168,bad 6,.939,good 8,.371,bad 9,.353,bad
View Diff
1,8c1,8 < 1,25.1%,good < 2,19.8%,bad < 3,30.5%,bad < 4,71.4%,good < 5,16.8%,bad < 6,93.9%,good < 8,37.1%,bad < 9,35.3%,bad --- > 1,.251,good > 2,.198,bad > 3,.305,bad > 4,.714,good > 5,.168,bad > 6,.939,good > 8,.371,bad > 9,.353,bad
Solutions by @anooplive:
Unlock 3 remaining solutions by signing in and submitting your own entry