No problem! The "csv" thing was only to try and make the formula look a little nicer. Here's the actual formula to use if you're looking for comma-separated values (Remember to use Ctrl+shift+enter):

=IF(MOD(ROW(),10)=1,LEFT(A1&","&A2&","&A3&","&A4&","&A5&","&A6&","&A7&","&A8&","&A9&","&A10,MAX(ISNUMBER(MID(A1&","&A2&","&A3&","&A4&","&A5&","&A6&","&A7&","&A8&","&A9&","&A10,ROW($1:$100),1)*1)*ROW($1:$100))),"")

If you're looking for semicolon-separated values, then use this:

=IF(MOD(ROW(),10)=1,LEFT(A1&";"&A2&";"&A3&";"&A4&";"&A5&";"&A6&";"&A7&";"&A8&";"&A9&";"&A10,MAX(ISNUMBER(MID(A1&";"&A2&";"&A3&";"&A4&";"&A5&";"&A6&";"&A7&";"&A8&";"&A9&";"&A10,ROW($1:$100),1)*1)*ROW($1:$100))),"")