Group set of values from a column to a comma separated row with a worksheet function

I have a few hundred rows with only values in column A.
I want to get groups of 10 values from column A and make this a comma separated string on every multiple of 10 row in column B (row 1,10,21 etc).
I simply want to drag and copy the same formula in each cell of column B and not have to manually insert a formula on every multiple of 10.

I DON'T want to use a Macro, just a worksheet function.
So the end result of calculated column B values should be:

A B
3 3,3,1,4,5,6,6,7,2,2
3
1
4
5
6
6
7
2
2
5 5,7,8,9,4,5,6,7,9,3
7
8
9
4
5
6
7
9
3
4 4,5,6,7,8
5
6
7
8

Sorry for my rookiness, but I'm not sure what you mean by:

where csv = A1&","&A2&","&A3&","&A4&","&A5&","&A6&","&A7&","&A8&","&A9&","&A10, where and how exactly do I define that?

ps I forgot to mention, but I use Excel 2013 so in my case the commas in your formula would be semicolons

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))),"")

I actually meant that I use Excel 2013 where the , in formulas has been replaced by ;. I still want the result of the calculation to be comma separated
I tried your new formula, but it gives me unexpected results, such as fewer than 10 cells in the result column.
Also when I remove rows at the end of the sheet, some calculated results in rows higher than the rows I remove seem to disappear
See my sheet here: www.in2medical.net/tmp.xlsx

I didn't realize your raw data includes letters as well. This is the formula to use for text and numbers (paste it into cell B1 and use ctrl+shift+enter):

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

Thanks! I've tried that too, but something is still amiss. I've uploaded a new version with some real data, but it seems your latest function does not take all data from all fields or the entire cell value. What can it be?
Thanks again!